{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Combine all Hochbahn data_25GB.ipynb","provenance":[{"file_id":"155S_bb3viIoL0wAwkIyr1r8XQu4ARwA9","timestamp":1600255366092}],"collapsed_sections":[],"toc_visible":true,"machine_shape":"hm"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"code","metadata":{"id":"tZRSiDYNQLSr"},"source":["# as you can see current ram is 12GB only, to increase it run below code"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"87T5BetZQYQv"},"source":["i = []\n","while True:\n","  i.append(i)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"YOckP_sYQcda"},"source":["# wait for few minutes, after that you will get a prompt that your notebook got crashed, do you want to increase ram ?"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"_F9FfyFSQl_5"},"source":["# in the prompt click - yes"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"xalsFDNyQp66"},"source":["# as you see the ram increase from 12GB to 25GB"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"XryjXIYhQ_gM"},"source":["#thanks for watching, keep learning "],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"ENUsRXFep4eb"},"source":["import glob\n","import pandas as pd\n","import numpy as np"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"nuhwuDujp5Eg","executionInfo":{"status":"ok","timestamp":1604103731444,"user_tz":-60,"elapsed":20649,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"05e79ff5-a5c8-40bb-b796-f39e51820bb5","colab":{"base_uri":"https://localhost:8080/"}},"source":["from google.colab import drive\n","drive.mount('/content/drive')"],"execution_count":null,"outputs":[{"output_type":"stream","text":["Mounted at /content/drive\n"],"name":"stdout"}]},{"cell_type":"markdown","metadata":{"id":"UKBKkmjFqFb_"},"source":["# Export for Visualization"]},{"cell_type":"code","metadata":{"id":"-wmDXYFHp95a"},"source":["# function for restrucuture data\n","def restructure_data(data):\n","    import datetime\n","    newdata = data[data['Fahrplanlage_IST'].notnull()].copy()\n","    newdata['Ab_ZT_PLAN'] = newdata['Ab_ZT_PLAN'].fillna(newdata['Ab_ZT_PLAN'].shift(1))\n","    \n","    #fill time at the end of the each trip table to be the same as departure time\n","    newdata['Ank_ZT_PLAN'] = 0\n","    newdata.loc[newdata['Wagen'].shift(-1).notnull(), 'Ank_ZT_PLAN'] = newdata['Ab_ZT_PLAN']\n","    newdata.loc[~newdata['Wagen'].shift(-1).notnull(), 'Ank_ZT_PLAN'] = newdata['Ab_ZT_PLAN'].shift(-1)\n","    #newdata['Ank_ZT_PLAN'] = newdata['Ank_ZT_PLAN'].fillna(newdata['Ank_ZT_PLAN'].shift(1))\n","    \n","    #find route name start-end station\n","    newdata['Haltestelle'] = newdata['Haltestelle'].fillna(newdata['Haltestelle'].shift(-1))\n","    #newdata['S_Station'] = \"\"\n","    #newdata['E_Station'] = \"\"\n","    newdata.loc[newdata['Wagen'].notnull(), 'S_Station'] = newdata['Haltestelle']\n","    #newdata.loc[newdata['Fahrplanlage_IST'].shift(1) != 'Fahrplanlage IST', 'S_Station'] = newdata['S_Station'].shift(1)\n","    \n","    newdata.loc[newdata['Wagen'].shift(-1).notnull(), 'E_Station'] = newdata['Haltestelle']\n","    #newdata.loc[newdata['Fahrplanlage_IST'].shift(-1)  != 'Fahrplanlage IST', 'Ank_ZT_PLAN'] = newdata['Ab_ZT_PLAN'].shift(-1)  \n","    \n","    \n","    #rearrage table and create new column for destination bus station\n","    #newdata = newdata.sort_values(['Wagen', 'Ank_ZT_PLAN'])\n","    #newdata.loc[newdata['Wagen'].shift(1) != newdata['Wagen'], 'NHaltestelle'] = 'Source'\n","    newdata.loc[newdata['Wagen'].shift(-1).isnull(), 'NHaltestelle'] = newdata['Haltestelle'].shift(-1)\n","    #newdata['NHaltestelle'] = newdata['Haltestelle'].shift(-1)\n","    newdata['NHaltestelle'] = newdata['NHaltestelle'].fillna(newdata['Haltestelle'].shift(-1))\n","    newdata['Node A to Node B']= newdata['Haltestelle']+\"|\"+ newdata['NHaltestelle']\n","    \n","    \n","    #Fill empty with above value\n","    #newdata['S_Station'].fillna(method='ffill', inplace=True)\n","    #newdata.fillna({'Datum':'ffill', 'UML':'ffill'}, inplace=True)\n","    #newdata.update(newdata[['Datum', 'UML']].fillna(method='ffill', inplace=True))\n","    newdata['Datum'].fillna(method='ffill', inplace=True)\n","    newdata['UML'].fillna(method='ffill', inplace=True)\n","    #newdata = newdata[newdata['Fahrplanlage_IST']!='Fahrplanlage IST']\n","    \n","\n","    #prevent wrong date data\n","    newdata['date'] = newdata['Datum'].astype(str).str[:10].replace('2020.', '2019.', regex=True)\n","    #newdata = newdata.drop('Datum', axis = 1)\n","    \n","           \n","    #change characteristic of departure and arrival\n","    newdata['Ab_ZT_PLAN'] = pd.to_datetime(newdata['date'] + ' ' + newdata['Ab_ZT_PLAN'], format='%d.%m.%Y %H:%M', errors='ignore')\n","    newdata['Ank_ZT_PLAN'] = pd.to_datetime(newdata['date'] + ' ' + newdata['Ank_ZT_PLAN'], format='%d.%m.%Y %H:%M', errors='ignore')\n","    \n","    newdata['Linie'] = newdata['Linie'].astype(str).str[:-2]\n","    newdata['UML'] = newdata['UML'].astype(str).str[:-2]\n","    #set journey ref\n","    newdata.loc[newdata['Wagen'].notnull(), 'JourneyRef'] = newdata['Ab_ZT_PLAN'].astype(str) + newdata['UML'] + newdata['Linie']\n","    newdata.loc[newdata['Wagen'].notnull(), 'S_Time'] = newdata['Ab_ZT_PLAN']\n","    newdata.loc[newdata['Wagen'].shift(-1).notnull(), 'E_Time'] = newdata['Ank_ZT_PLAN']\n","\n","    #Fill empty with below value\n","    newdata['E_Station'].fillna(method='bfill', inplace=True)\n","    newdata['E_Time'].fillna(method='bfill', inplace=True)\n","    #Fill empty with above value\n","    newdata.fillna(method='ffill', inplace=True)\n","    \n","    newdata['Wagen'] = newdata['Wagen'].astype(str).str[:-2]\n","\n","    newdata['Fahrplanlage_IST'] = pd.to_numeric( newdata['Fahrplanlage_IST'].astype(str).replace(',', '', regex = True))\n","    #actual time calculate from minute late\n","    newdata['Ab_ZT_ACTUAL'] = newdata['Ab_ZT_PLAN']+pd.to_timedelta(newdata['Fahrplanlage_IST'], unit='min')\n","    \n","    newdata.loc[newdata['Ab_ZT_PLAN']  == newdata['Ank_ZT_PLAN'], 'Ank_ZT_ACTUAL'] = newdata['Ab_ZT_ACTUAL']\n","    newdata['Ank_ZT_ACTUAL'] = newdata['Ank_ZT_ACTUAL'].fillna(newdata['Ab_ZT_ACTUAL'].shift(-1))\n","    #newdata['Ank_ZT_ACTUAL'] = newdata['Ab_ZT_ACTUAL'].shift(-1)\n","    \n","    #calculate driving time and distance\n","    newdata['Driving_time_s'] = (pd.to_datetime(newdata['Ank_ZT_ACTUAL']) - pd.to_datetime(newdata['Ab_ZT_ACTUAL'])).dt.total_seconds() \n","    newdata['Distance_m'] = pd.to_numeric( newdata['v_IST'].astype(str).replace(',|-', '', regex = True)) * 10/36 * newdata['Driving_time_s']\n","    newdata['Driving_time_s_p'] = (pd.to_datetime(newdata['Ank_ZT_PLAN']) - pd.to_datetime(newdata['Ab_ZT_PLAN'])).dt.total_seconds() \n","    newdata['Distance_m_p'] = pd.to_numeric( newdata['v_PLAN'].astype(str).replace(',|-', '', regex = True)) * 10/36 * newdata['Driving_time_s_p']\n","    \n","    selectdata = newdata[['JourneyRef', 'UML', 'Wagen', 'Linie','S_Time', 'S_Station', 'E_Station', 'E_Time','Driving_time_s', 'Distance_m', 'Driving_time_s_p', 'Distance_m_p']]\n","    gb = selectdata.groupby(['JourneyRef','UML', 'Wagen', 'Linie','S_Time', 'S_Station', 'E_Station', 'E_Time']).sum().reset_index()\n","    return gb #newdata"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"Gn5lMIqJJ2QV","executionInfo":{"status":"ok","timestamp":1604105889227,"user_tz":-60,"elapsed":24855,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"f8ca9627-cec6-445a-e465-f4b704992566","colab":{"base_uri":"https://localhost:8080/"}},"source":["df = pd.read_csv('/content/drive/My Drive/Colab Notebooks/Fahrten BBD BBW 01.03.2019-30.09.2019/bkf06_t.csv', sep=',',skiprows=3,\n","                  names = ['Datum','UML','Wagen','Ab_ZT_PLAN','Linie','Haltestelle','Fahrplanlage_IST','v_PLAN','v_IST_S2S1','v_netto_S2S1','FFVP_GESCHWINDIGKEIT','v_IST'\n","                          ])\n","#df['date'] = date_list[i]\n","#df['line'] = line_list[i]\n","\n","df = restructure_data(df)"],"execution_count":null,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.6/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (6) have mixed types.Specify dtype option on import or set low_memory=False.\n","  interactivity=interactivity, compiler=compiler, result=result)\n"],"name":"stderr"}]},{"cell_type":"code","metadata":{"id":"DPU_GqAPKFQ1","executionInfo":{"status":"ok","timestamp":1604105889231,"user_tz":-60,"elapsed":23072,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"e0111c75-049c-431f-f749-1107a750138f","colab":{"base_uri":"https://localhost:8080/","height":779}},"source":["df"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>JourneyRef</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Linie</th>\n","      <th>S_Time</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>E_Time</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2019-09-01 00:00:007705825</td>\n","      <td>77058</td>\n","      <td>7337</td>\n","      <td>25</td>\n","      <td>2019-09-01 00:00:00</td>\n","      <td>Max-Brauer-Allee (Mitte)</td>\n","      <td>S Holstenstraße</td>\n","      <td>2019-09-01 23:58:00</td>\n","      <td>86310.0</td>\n","      <td>14357.500000</td>\n","      <td>86280.0</td>\n","      <td>13845.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2019-09-01 00:00:00771197</td>\n","      <td>77119</td>\n","      <td>4706</td>\n","      <td>7</td>\n","      <td>2019-09-01 00:00:00</td>\n","      <td>Gründgensstraße (West)</td>\n","      <td>Eichenlohweg</td>\n","      <td>2019-09-01 23:59:00</td>\n","      <td>86328.0</td>\n","      <td>4507.000000</td>\n","      <td>86340.0</td>\n","      <td>4620.000000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2019-09-01 00:00:0077122173</td>\n","      <td>77122</td>\n","      <td>1731</td>\n","      <td>173</td>\n","      <td>2019-09-01 00:00:00</td>\n","      <td>Schumannstraße</td>\n","      <td>Beethovenstraße</td>\n","      <td>2019-09-01 23:58:00</td>\n","      <td>86352.0</td>\n","      <td>4018.666667</td>\n","      <td>86280.0</td>\n","      <td>3985.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2019-09-01 00:00:007712317</td>\n","      <td>77123</td>\n","      <td>3925</td>\n","      <td>17</td>\n","      <td>2019-09-01 00:00:00</td>\n","      <td>U St.Pauli</td>\n","      <td>Michaeliskirche</td>\n","      <td>2019-09-01 23:58:00</td>\n","      <td>86256.0</td>\n","      <td>6969.333333</td>\n","      <td>86280.0</td>\n","      <td>6711.666667</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2019-09-01 00:00:007712417</td>\n","      <td>77124</td>\n","      <td>6911</td>\n","      <td>17</td>\n","      <td>2019-09-01 00:00:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>AK St.Georg</td>\n","      <td>2019-09-01 23:57:00</td>\n","      <td>86250.0</td>\n","      <td>597341.666667</td>\n","      <td>86220.0</td>\n","      <td>645945.000000</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>68198</th>\n","      <td>2019-09-24 22:11:0077014174</td>\n","      <td>77014</td>\n","      <td>6011</td>\n","      <td>174</td>\n","      <td>2019-09-24 22:11:00</td>\n","      <td>U Volksdorf</td>\n","      <td>S Poppenbüttel (Wentzelplatz)</td>\n","      <td>2019-09-24 22:25:00</td>\n","      <td>918.0</td>\n","      <td>7416.833333</td>\n","      <td>840.0</td>\n","      <td>7643.333333</td>\n","    </tr>\n","    <tr>\n","      <th>68199</th>\n","      <td>2019-09-24 22:26:0077014174</td>\n","      <td>77014</td>\n","      <td>6011</td>\n","      <td>174</td>\n","      <td>2019-09-24 22:26:00</td>\n","      <td>S Poppenbüttel (Wentzelplatz)</td>\n","      <td>S Poppenbüttel (Wentzelplatz)</td>\n","      <td>2019-09-24 22:26:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>68200</th>\n","      <td>2019-09-24 22:37:00770016</td>\n","      <td>77001</td>\n","      <td>7283</td>\n","      <td>6</td>\n","      <td>2019-09-24 22:37:00</td>\n","      <td>Am Sandtorkai</td>\n","      <td>Gertigstraße</td>\n","      <td>2019-09-24 22:58:00</td>\n","      <td>1194.0</td>\n","      <td>5289.166667</td>\n","      <td>1200.0</td>\n","      <td>5260.000000</td>\n","    </tr>\n","    <tr>\n","      <th>68201</th>\n","      <td>2019-09-24 22:37:00770016</td>\n","      <td>77001</td>\n","      <td>7283</td>\n","      <td>n</td>\n","      <td>2019-09-24 22:37:00</td>\n","      <td>Am Sandtorkai</td>\n","      <td>Gertigstraße</td>\n","      <td>2019-09-24 22:58:00</td>\n","      <td>90.0</td>\n","      <td>392.500000</td>\n","      <td>60.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>68202</th>\n","      <td>2019-09-24 23:20:0077001213</td>\n","      <td>77001</td>\n","      <td>7283</td>\n","      <td>213</td>\n","      <td>2019-09-24 23:20:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U Billstedt</td>\n","      <td>2019-09-24 23:48:00</td>\n","      <td>1596.0</td>\n","      <td>8554.000000</td>\n","      <td>1680.0</td>\n","      <td>8705.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>68203 rows × 12 columns</p>\n","</div>"],"text/plain":["                        JourneyRef    UML  ... Driving_time_s_p   Distance_m_p\n","0       2019-09-01 00:00:007705825  77058  ...          86280.0   13845.000000\n","1        2019-09-01 00:00:00771197  77119  ...          86340.0    4620.000000\n","2      2019-09-01 00:00:0077122173  77122  ...          86280.0    3985.000000\n","3       2019-09-01 00:00:007712317  77123  ...          86280.0    6711.666667\n","4       2019-09-01 00:00:007712417  77124  ...          86220.0  645945.000000\n","...                            ...    ...  ...              ...            ...\n","68198  2019-09-24 22:11:0077014174  77014  ...            840.0    7643.333333\n","68199  2019-09-24 22:26:0077014174  77014  ...              0.0       0.000000\n","68200    2019-09-24 22:37:00770016  77001  ...           1200.0    5260.000000\n","68201    2019-09-24 22:37:00770016  77001  ...             60.0       0.000000\n","68202  2019-09-24 23:20:0077001213  77001  ...           1680.0    8705.000000\n","\n","[68203 rows x 12 columns]"]},"metadata":{"tags":[]},"execution_count":16}]},{"cell_type":"code","metadata":{"id":"M-1tE-OxqJvF","executionInfo":{"status":"ok","timestamp":1604106379094,"user_tz":-60,"elapsed":457311,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"dc1195d4-fd2b-4864-f9f8-d6f35dff768b","colab":{"base_uri":"https://localhost:8080/"}},"source":["path =r'/content/drive/My Drive/Colab Notebooks/Fahrten BBD BBW 01.03.2019-30.09.2019' # use your path\n","allFiles = glob.glob(path + \"/*.csv\")\n","\n","date_list = [allFile[-15:-5] for allFile in allFiles]\n","#line_list = [allFile[-21:-16] for allFile in allFiles]\n","\n","list_ = []\n","i=0\n","\n","\n","for file_ in allFiles:\n","    df = pd.read_csv(file_, sep=',',skiprows=3,\n","                      names = ['Datum','UML','Wagen','Ab_ZT_PLAN','Linie','Haltestelle','Fahrplanlage_IST','v_PLAN','v_IST_S2S1','v_netto_S2S1','FFVP_GESCHWINDIGKEIT','v_IST'\n","                              ])\n","    #df['date'] = date_list[i]\n","    #df['line'] = line_list[i]\n","\n","    df = restructure_data(df)\n","    list_.append(df)\n","    i+=1\n","\n","data = pd.concat(list_, axis = 0, ignore_index = True)"],"execution_count":null,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.6/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (6) have mixed types.Specify dtype option on import or set low_memory=False.\n","  interactivity=interactivity, compiler=compiler, result=result)\n","/usr/local/lib/python3.6/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (4,6) have mixed types.Specify dtype option on import or set low_memory=False.\n","  interactivity=interactivity, compiler=compiler, result=result)\n"],"name":"stderr"}]},{"cell_type":"code","metadata":{"id":"MRKO9oSSqM-w","executionInfo":{"status":"ok","timestamp":1604106379096,"user_tz":-60,"elapsed":453782,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"a4436039-8139-4e02-92e7-72c455ef374f","colab":{"base_uri":"https://localhost:8080/","height":1000}},"source":["data[-50:]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>JourneyRef</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Linie</th>\n","      <th>S_Time</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>E_Time</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1403457</th>\n","      <td>2019-10-24 22:55:007707623</td>\n","      <td>77076</td>\n","      <td>1912</td>\n","      <td>23</td>\n","      <td>2019-10-24 22:55:00</td>\n","      <td>U Billstedt</td>\n","      <td>U Niendorf Markt</td>\n","      <td>2019-10-24 23:57:00</td>\n","      <td>3096.0</td>\n","      <td>18866.666667</td>\n","      <td>3480.0</td>\n","      <td>18848.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403458</th>\n","      <td>2019-10-24 22:55:007707623</td>\n","      <td>77076</td>\n","      <td>1912</td>\n","      <td>n</td>\n","      <td>2019-10-24 22:55:00</td>\n","      <td>U Billstedt</td>\n","      <td>U Niendorf Markt</td>\n","      <td>2019-10-24 23:57:00</td>\n","      <td>414.0</td>\n","      <td>1368.500000</td>\n","      <td>240.0</td>\n","      <td>1453.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403459</th>\n","      <td>2019-10-24 22:56:00772777</td>\n","      <td>77277</td>\n","      <td>7526</td>\n","      <td>7</td>\n","      <td>2019-10-24 22:56:00</td>\n","      <td>Borchertring</td>\n","      <td>Borchertring</td>\n","      <td>2019-10-24 22:56:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403460</th>\n","      <td>2019-10-24 22:57:00772655</td>\n","      <td>77265</td>\n","      <td>4927</td>\n","      <td>5</td>\n","      <td>2019-10-24 22:57:00</td>\n","      <td>A Burgwedel</td>\n","      <td>Hauptbahnhof/Mönckebergstraße</td>\n","      <td>2019-10-24 23:37:00</td>\n","      <td>2532.0</td>\n","      <td>13690.333333</td>\n","      <td>2400.0</td>\n","      <td>13555.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403461</th>\n","      <td>2019-10-24 22:58:0077089177</td>\n","      <td>77089</td>\n","      <td>1109</td>\n","      <td>177</td>\n","      <td>2019-10-24 22:58:00</td>\n","      <td>Borchertring</td>\n","      <td>Borchertring</td>\n","      <td>2019-10-24 22:58:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403462</th>\n","      <td>2019-10-24 22:58:00772377</td>\n","      <td>77237</td>\n","      <td>4805</td>\n","      <td>7</td>\n","      <td>2019-10-24 22:58:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:11:00</td>\n","      <td>744.0</td>\n","      <td>4516.333333</td>\n","      <td>720.0</td>\n","      <td>4633.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403463</th>\n","      <td>2019-10-24 22:58:00772377</td>\n","      <td>77237</td>\n","      <td>4805</td>\n","      <td>n</td>\n","      <td>2019-10-24 22:58:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:11:00</td>\n","      <td>36.0</td>\n","      <td>314.000000</td>\n","      <td>60.0</td>\n","      <td>288.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403464</th>\n","      <td>2019-10-24 22:58:00772616</td>\n","      <td>77261</td>\n","      <td>7916</td>\n","      <td>6</td>\n","      <td>2019-10-24 22:58:00</td>\n","      <td>Am Sandtorkai</td>\n","      <td>Gertigstraße</td>\n","      <td>2019-10-24 23:19:00</td>\n","      <td>1098.0</td>\n","      <td>4025.666667</td>\n","      <td>1200.0</td>\n","      <td>6143.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403465</th>\n","      <td>2019-10-24 22:58:00772616</td>\n","      <td>77261</td>\n","      <td>7916</td>\n","      <td>n</td>\n","      <td>2019-10-24 22:58:00</td>\n","      <td>Am Sandtorkai</td>\n","      <td>Gertigstraße</td>\n","      <td>2019-10-24 23:19:00</td>\n","      <td>156.0</td>\n","      <td>186.333333</td>\n","      <td>60.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403466</th>\n","      <td>2019-10-24 22:58:0077272368</td>\n","      <td>77272</td>\n","      <td>1993</td>\n","      <td>368</td>\n","      <td>2019-10-24 22:58:00</td>\n","      <td>U Berne (Berner Heerweg)</td>\n","      <td>Bf. Rahlstedt (Doberaner Weg)</td>\n","      <td>2019-10-24 23:20:00</td>\n","      <td>1356.0</td>\n","      <td>7196.333333</td>\n","      <td>1320.0</td>\n","      <td>7238.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403467</th>\n","      <td>2019-10-24 23:01:00772047</td>\n","      <td>77204</td>\n","      <td>4911</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:01:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Borchertring</td>\n","      <td>2019-10-24 23:15:00</td>\n","      <td>804.0</td>\n","      <td>4992.000000</td>\n","      <td>840.0</td>\n","      <td>5143.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403468</th>\n","      <td>2019-10-24 23:01:0077222173</td>\n","      <td>77222</td>\n","      <td>1860</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:01:00</td>\n","      <td>Am Stühm-Süd</td>\n","      <td>Am Stühm-Süd</td>\n","      <td>2019-10-24 23:01:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403469</th>\n","      <td>2019-10-24 23:02:0077161173</td>\n","      <td>77161</td>\n","      <td>1618</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:02:00</td>\n","      <td>Am Stühm-Süd</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:21:00</td>\n","      <td>948.0</td>\n","      <td>6262.000000</td>\n","      <td>1140.0</td>\n","      <td>6730.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403470</th>\n","      <td>2019-10-24 23:02:0077164173</td>\n","      <td>77164</td>\n","      <td>6932</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:02:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:02:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403471</th>\n","      <td>2019-10-24 23:03:00771446</td>\n","      <td>77144</td>\n","      <td>7456</td>\n","      <td>6</td>\n","      <td>2019-10-24 23:03:00</td>\n","      <td>Auf dem Sande (Speicherstadt)</td>\n","      <td>Auf dem Sande (Speicherstadt)</td>\n","      <td>2019-10-24 23:03:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403472</th>\n","      <td>2019-10-24 23:03:007715723</td>\n","      <td>77157</td>\n","      <td>1619</td>\n","      <td>23</td>\n","      <td>2019-10-24 23:03:00</td>\n","      <td>U Niendorf Markt</td>\n","      <td>U Niendorf Markt</td>\n","      <td>2019-10-24 23:03:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403473</th>\n","      <td>2019-10-24 23:06:0077228173</td>\n","      <td>77228</td>\n","      <td>1717</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:06:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Am Stühm-Süd</td>\n","      <td>2019-10-24 23:40:00</td>\n","      <td>2010.0</td>\n","      <td>44117.333333</td>\n","      <td>2040.0</td>\n","      <td>10973.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403474</th>\n","      <td>2019-10-24 23:07:0077278114</td>\n","      <td>77278</td>\n","      <td>1815</td>\n","      <td>114</td>\n","      <td>2019-10-24 23:07:00</td>\n","      <td>U Klosterstern</td>\n","      <td>Am Licentiatenberg</td>\n","      <td>2019-10-24 23:26:00</td>\n","      <td>1140.0</td>\n","      <td>4863.333333</td>\n","      <td>1140.0</td>\n","      <td>5398.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403475</th>\n","      <td>2019-10-24 23:08:0077118174</td>\n","      <td>77118</td>\n","      <td>1401</td>\n","      <td>174</td>\n","      <td>2019-10-24 23:08:00</td>\n","      <td>Tegelsbarg (Nord)</td>\n","      <td>Tegelsbarg (Nord)</td>\n","      <td>2019-10-24 23:08:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403476</th>\n","      <td>2019-10-24 23:08:00771557</td>\n","      <td>77155</td>\n","      <td>4909</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:08:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:21:00</td>\n","      <td>792.0</td>\n","      <td>4526.333333</td>\n","      <td>720.0</td>\n","      <td>4633.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403477</th>\n","      <td>2019-10-24 23:08:00771557</td>\n","      <td>77155</td>\n","      <td>4909</td>\n","      <td>n</td>\n","      <td>2019-10-24 23:08:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:21:00</td>\n","      <td>18.0</td>\n","      <td>235.500000</td>\n","      <td>60.0</td>\n","      <td>288.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403478</th>\n","      <td>2019-10-24 23:11:00770607</td>\n","      <td>77060</td>\n","      <td>4917</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:11:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Borchertring</td>\n","      <td>2019-10-24 23:25:00</td>\n","      <td>852.0</td>\n","      <td>4902.333333</td>\n","      <td>840.0</td>\n","      <td>5143.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403479</th>\n","      <td>2019-10-24 23:11:0077097171</td>\n","      <td>77097</td>\n","      <td>2902</td>\n","      <td>171</td>\n","      <td>2019-10-24 23:11:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:11:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403480</th>\n","      <td>2019-10-24 23:11:007727325</td>\n","      <td>77273</td>\n","      <td>7340</td>\n","      <td>25</td>\n","      <td>2019-10-24 23:11:00</td>\n","      <td>Bf. Altona</td>\n","      <td>Bf. Altona</td>\n","      <td>2019-10-24 23:11:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403481</th>\n","      <td>2019-10-24 23:15:0077087213</td>\n","      <td>77087</td>\n","      <td>1704</td>\n","      <td>213</td>\n","      <td>2019-10-24 23:15:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:15:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403482</th>\n","      <td>2019-10-24 23:16:0077100174</td>\n","      <td>77100</td>\n","      <td>1930</td>\n","      <td>174</td>\n","      <td>2019-10-24 23:16:00</td>\n","      <td>S Poppenbüttel (Wentzelplatz)</td>\n","      <td>U S Ohlsdorf (Im Grünen Grunde)</td>\n","      <td>2019-10-24 23:51:00</td>\n","      <td>2178.0</td>\n","      <td>12586.333333</td>\n","      <td>2100.0</td>\n","      <td>13040.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403483</th>\n","      <td>2019-10-24 23:16:0077164173</td>\n","      <td>77164</td>\n","      <td>6932</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:16:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:32:00</td>\n","      <td>792.0</td>\n","      <td>4304.000000</td>\n","      <td>960.0</td>\n","      <td>4276.666667</td>\n","    </tr>\n","    <tr>\n","      <th>1403484</th>\n","      <td>2019-10-24 23:18:007710523</td>\n","      <td>77105</td>\n","      <td>1035</td>\n","      <td>23</td>\n","      <td>2019-10-24 23:18:00</td>\n","      <td>U Niendorf Markt</td>\n","      <td>U Niendorf Markt</td>\n","      <td>2019-10-24 23:18:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403485</th>\n","      <td>2019-10-24 23:18:0077152114</td>\n","      <td>77152</td>\n","      <td>1933</td>\n","      <td>114</td>\n","      <td>2019-10-24 23:18:00</td>\n","      <td>Am Licentiatenberg</td>\n","      <td>U Klosterstern</td>\n","      <td>2019-10-24 23:35:00</td>\n","      <td>990.0</td>\n","      <td>5546.000000</td>\n","      <td>1020.0</td>\n","      <td>5655.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403486</th>\n","      <td>2019-10-24 23:18:00772047</td>\n","      <td>77204</td>\n","      <td>4911</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:18:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:31:00</td>\n","      <td>792.0</td>\n","      <td>4544.666667</td>\n","      <td>720.0</td>\n","      <td>4633.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403487</th>\n","      <td>2019-10-24 23:18:00772047</td>\n","      <td>77204</td>\n","      <td>4911</td>\n","      <td>n</td>\n","      <td>2019-10-24 23:18:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:31:00</td>\n","      <td>48.0</td>\n","      <td>364.000000</td>\n","      <td>60.0</td>\n","      <td>288.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403488</th>\n","      <td>2019-10-24 23:20:0077001213</td>\n","      <td>77001</td>\n","      <td>7802</td>\n","      <td>213</td>\n","      <td>2019-10-24 23:20:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U Billstedt</td>\n","      <td>2019-10-24 23:48:00</td>\n","      <td>1656.0</td>\n","      <td>8555.333333</td>\n","      <td>1680.0</td>\n","      <td>8705.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403489</th>\n","      <td>2019-10-24 23:21:00772377</td>\n","      <td>77237</td>\n","      <td>4805</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:21:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Borchertring</td>\n","      <td>2019-10-24 23:35:00</td>\n","      <td>924.0</td>\n","      <td>4906.333333</td>\n","      <td>840.0</td>\n","      <td>5143.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403490</th>\n","      <td>2019-10-24 23:22:0077161173</td>\n","      <td>77161</td>\n","      <td>1618</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:22:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:22:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403491</th>\n","      <td>2019-10-24 23:22:0077275173</td>\n","      <td>77275</td>\n","      <td>6913</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:22:00</td>\n","      <td>Am Stühm-Süd</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:41:00</td>\n","      <td>984.0</td>\n","      <td>6608.833333</td>\n","      <td>1140.0</td>\n","      <td>6730.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403492</th>\n","      <td>2019-10-24 23:24:0077128171</td>\n","      <td>77128</td>\n","      <td>6021</td>\n","      <td>171</td>\n","      <td>2019-10-24 23:24:00</td>\n","      <td>U Farmsen</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:50:00</td>\n","      <td>1512.0</td>\n","      <td>8327.166667</td>\n","      <td>1560.0</td>\n","      <td>9116.666667</td>\n","    </tr>\n","    <tr>\n","      <th>1403493</th>\n","      <td>2019-10-24 23:28:00770607</td>\n","      <td>77060</td>\n","      <td>4917</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:28:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:41:00</td>\n","      <td>720.0</td>\n","      <td>4543.833333</td>\n","      <td>720.0</td>\n","      <td>4633.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403494</th>\n","      <td>2019-10-24 23:28:00770607</td>\n","      <td>77060</td>\n","      <td>4917</td>\n","      <td>n</td>\n","      <td>2019-10-24 23:28:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:41:00</td>\n","      <td>36.0</td>\n","      <td>280.000000</td>\n","      <td>60.0</td>\n","      <td>288.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403495</th>\n","      <td>2019-10-24 23:30:0077157171</td>\n","      <td>77157</td>\n","      <td>1619</td>\n","      <td>171</td>\n","      <td>2019-10-24 23:30:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U Farmsen</td>\n","      <td>2019-10-24 23:57:00</td>\n","      <td>1554.0</td>\n","      <td>9090.333333</td>\n","      <td>1620.0</td>\n","      <td>9178.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403496</th>\n","      <td>2019-10-24 23:31:00771557</td>\n","      <td>77155</td>\n","      <td>4909</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:31:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Borchertring</td>\n","      <td>2019-10-24 23:45:00</td>\n","      <td>906.0</td>\n","      <td>4959.333333</td>\n","      <td>840.0</td>\n","      <td>5143.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403497</th>\n","      <td>2019-10-24 23:33:0077222173</td>\n","      <td>77222</td>\n","      <td>1860</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:33:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>2019-10-24 23:49:00</td>\n","      <td>876.0</td>\n","      <td>4841.333333</td>\n","      <td>960.0</td>\n","      <td>4801.666667</td>\n","    </tr>\n","    <tr>\n","      <th>1403498</th>\n","      <td>2019-10-24 23:36:0077152114</td>\n","      <td>77152</td>\n","      <td>1933</td>\n","      <td>114</td>\n","      <td>2019-10-24 23:36:00</td>\n","      <td>U Klosterstern</td>\n","      <td>U Klosterstern</td>\n","      <td>2019-10-24 23:36:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403499</th>\n","      <td>2019-10-24 23:38:00772377</td>\n","      <td>77237</td>\n","      <td>4805</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:38:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:51:00</td>\n","      <td>654.0</td>\n","      <td>4481.500000</td>\n","      <td>720.0</td>\n","      <td>4633.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403500</th>\n","      <td>2019-10-24 23:38:00772377</td>\n","      <td>77237</td>\n","      <td>4805</td>\n","      <td>n</td>\n","      <td>2019-10-24 23:38:00</td>\n","      <td>Borchertring</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:51:00</td>\n","      <td>30.0</td>\n","      <td>308.333333</td>\n","      <td>60.0</td>\n","      <td>288.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403501</th>\n","      <td>2019-10-24 23:40:00772655</td>\n","      <td>77265</td>\n","      <td>4927</td>\n","      <td>5</td>\n","      <td>2019-10-24 23:40:00</td>\n","      <td>Hauptbahnhof/ZOB</td>\n","      <td>Hauptbahnhof/ZOB</td>\n","      <td>2019-10-24 23:40:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403502</th>\n","      <td>2019-10-24 23:41:00772047</td>\n","      <td>77204</td>\n","      <td>4911</td>\n","      <td>7</td>\n","      <td>2019-10-24 23:41:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Borchertring</td>\n","      <td>2019-10-24 23:55:00</td>\n","      <td>864.0</td>\n","      <td>4881.000000</td>\n","      <td>840.0</td>\n","      <td>5143.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403503</th>\n","      <td>2019-10-24 23:42:0077164173</td>\n","      <td>77164</td>\n","      <td>6932</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:42:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Am Stühm-Süd</td>\n","      <td>2019-10-24 23:59:00</td>\n","      <td>960.0</td>\n","      <td>6568.166667</td>\n","      <td>1020.0</td>\n","      <td>6583.333333</td>\n","    </tr>\n","    <tr>\n","      <th>1403504</th>\n","      <td>2019-10-24 23:42:0077275173</td>\n","      <td>77275</td>\n","      <td>6913</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:42:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-10-24 23:42:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403505</th>\n","      <td>2019-10-24 23:50:0077222173</td>\n","      <td>77222</td>\n","      <td>1860</td>\n","      <td>173</td>\n","      <td>2019-10-24 23:50:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>2019-10-24 23:50:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1403506</th>\n","      <td>2019-10-24 23:58:007707623</td>\n","      <td>77076</td>\n","      <td>1912</td>\n","      <td>23</td>\n","      <td>2019-10-24 23:58:00</td>\n","      <td>U Niendorf Markt</td>\n","      <td>U Niendorf Markt</td>\n","      <td>2019-10-24 23:58:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                          JourneyRef    UML  ... Driving_time_s_p  Distance_m_p\n","1403457   2019-10-24 22:55:007707623  77076  ...           3480.0  18848.333333\n","1403458   2019-10-24 22:55:007707623  77076  ...            240.0   1453.333333\n","1403459    2019-10-24 22:56:00772777  77277  ...              0.0      0.000000\n","1403460    2019-10-24 22:57:00772655  77265  ...           2400.0  13555.000000\n","1403461  2019-10-24 22:58:0077089177  77089  ...              0.0      0.000000\n","1403462    2019-10-24 22:58:00772377  77237  ...            720.0   4633.333333\n","1403463    2019-10-24 22:58:00772377  77237  ...             60.0    288.333333\n","1403464    2019-10-24 22:58:00772616  77261  ...           1200.0   6143.333333\n","1403465    2019-10-24 22:58:00772616  77261  ...             60.0      0.000000\n","1403466  2019-10-24 22:58:0077272368  77272  ...           1320.0   7238.333333\n","1403467    2019-10-24 23:01:00772047  77204  ...            840.0   5143.333333\n","1403468  2019-10-24 23:01:0077222173  77222  ...              0.0      0.000000\n","1403469  2019-10-24 23:02:0077161173  77161  ...           1140.0   6730.000000\n","1403470  2019-10-24 23:02:0077164173  77164  ...              0.0      0.000000\n","1403471    2019-10-24 23:03:00771446  77144  ...              0.0      0.000000\n","1403472   2019-10-24 23:03:007715723  77157  ...              0.0      0.000000\n","1403473  2019-10-24 23:06:0077228173  77228  ...           2040.0  10973.333333\n","1403474  2019-10-24 23:07:0077278114  77278  ...           1140.0   5398.333333\n","1403475  2019-10-24 23:08:0077118174  77118  ...              0.0      0.000000\n","1403476    2019-10-24 23:08:00771557  77155  ...            720.0   4633.333333\n","1403477    2019-10-24 23:08:00771557  77155  ...             60.0    288.333333\n","1403478    2019-10-24 23:11:00770607  77060  ...            840.0   5143.333333\n","1403479  2019-10-24 23:11:0077097171  77097  ...              0.0      0.000000\n","1403480   2019-10-24 23:11:007727325  77273  ...              0.0      0.000000\n","1403481  2019-10-24 23:15:0077087213  77087  ...              0.0      0.000000\n","1403482  2019-10-24 23:16:0077100174  77100  ...           2100.0  13040.000000\n","1403483  2019-10-24 23:16:0077164173  77164  ...            960.0   4276.666667\n","1403484   2019-10-24 23:18:007710523  77105  ...              0.0      0.000000\n","1403485  2019-10-24 23:18:0077152114  77152  ...           1020.0   5655.000000\n","1403486    2019-10-24 23:18:00772047  77204  ...            720.0   4633.333333\n","1403487    2019-10-24 23:18:00772047  77204  ...             60.0    288.333333\n","1403488  2019-10-24 23:20:0077001213  77001  ...           1680.0   8705.000000\n","1403489    2019-10-24 23:21:00772377  77237  ...            840.0   5143.333333\n","1403490  2019-10-24 23:22:0077161173  77161  ...              0.0      0.000000\n","1403491  2019-10-24 23:22:0077275173  77275  ...           1140.0   6730.000000\n","1403492  2019-10-24 23:24:0077128171  77128  ...           1560.0   9116.666667\n","1403493    2019-10-24 23:28:00770607  77060  ...            720.0   4633.333333\n","1403494    2019-10-24 23:28:00770607  77060  ...             60.0    288.333333\n","1403495  2019-10-24 23:30:0077157171  77157  ...           1620.0   9178.333333\n","1403496    2019-10-24 23:31:00771557  77155  ...            840.0   5143.333333\n","1403497  2019-10-24 23:33:0077222173  77222  ...            960.0   4801.666667\n","1403498  2019-10-24 23:36:0077152114  77152  ...              0.0      0.000000\n","1403499    2019-10-24 23:38:00772377  77237  ...            720.0   4633.333333\n","1403500    2019-10-24 23:38:00772377  77237  ...             60.0    288.333333\n","1403501    2019-10-24 23:40:00772655  77265  ...              0.0      0.000000\n","1403502    2019-10-24 23:41:00772047  77204  ...            840.0   5143.333333\n","1403503  2019-10-24 23:42:0077164173  77164  ...           1020.0   6583.333333\n","1403504  2019-10-24 23:42:0077275173  77275  ...              0.0      0.000000\n","1403505  2019-10-24 23:50:0077222173  77222  ...              0.0      0.000000\n","1403506   2019-10-24 23:58:007707623  77076  ...              0.0      0.000000\n","\n","[50 rows x 12 columns]"]},"metadata":{"tags":[]},"execution_count":18}]},{"cell_type":"code","metadata":{"id":"kHyT9Vjuw6Wd","executionInfo":{"status":"ok","timestamp":1604102278168,"user_tz":-60,"elapsed":1749,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"32662f47-1ce9-441a-e975-741be1c49cbb","colab":{"base_uri":"https://localhost:8080/","height":759}},"source":["gb = data.groupby(['JourneyRef','UML', 'Wagen', 'Linie','S_Time', 'S_Station', 'E_Station', 'E_Time']).sum().reset_index()\n","gb"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>JourneyRef</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Linie</th>\n","      <th>S_Time</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>E_Time</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2019-05-01 00:00:007705325</td>\n","      <td>77053</td>\n","      <td>7435</td>\n","      <td>25</td>\n","      <td>2019-05-01 00:00:00</td>\n","      <td>Max-Brauer-Allee (Mitte)</td>\n","      <td>S Holstenstraße</td>\n","      <td>2019-05-01 23:58:00</td>\n","      <td>86340.0</td>\n","      <td>13377.166667</td>\n","      <td>86280.0</td>\n","      <td>378870.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2019-05-01 00:00:0077108172</td>\n","      <td>77108</td>\n","      <td>1314</td>\n","      <td>172</td>\n","      <td>2019-05-01 00:00:00</td>\n","      <td>Herderstraße</td>\n","      <td>Jarrestraße (Kampnagel)</td>\n","      <td>2019-05-01 23:58:00</td>\n","      <td>86256.0</td>\n","      <td>8866.000000</td>\n","      <td>86280.0</td>\n","      <td>9046.666667</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2019-05-01 00:00:00771097</td>\n","      <td>77109</td>\n","      <td>7308</td>\n","      <td>7</td>\n","      <td>2019-05-01 00:00:00</td>\n","      <td>Gründgensstraße (West)</td>\n","      <td>Eichenlohweg</td>\n","      <td>2019-05-01 23:59:00</td>\n","      <td>86316.0</td>\n","      <td>4407.666667</td>\n","      <td>86340.0</td>\n","      <td>4620.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2019-05-01 00:00:0077113173</td>\n","      <td>77113</td>\n","      <td>1117</td>\n","      <td>173</td>\n","      <td>2019-05-01 00:00:00</td>\n","      <td>Beethovenstraße</td>\n","      <td>U Mundsburg</td>\n","      <td>2019-05-01 23:58:00</td>\n","      <td>86298.0</td>\n","      <td>3987.500000</td>\n","      <td>86280.0</td>\n","      <td>3618.333333</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2019-05-01 00:00:007711617</td>\n","      <td>77116</td>\n","      <td>7618</td>\n","      <td>17</td>\n","      <td>2019-05-01 00:00:00</td>\n","      <td>U St.Pauli</td>\n","      <td>Michaeliskirche</td>\n","      <td>2019-05-01 23:58:00</td>\n","      <td>86232.0</td>\n","      <td>8369.833333</td>\n","      <td>86280.0</td>\n","      <td>8176.666667</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>67423</th>\n","      <td>2019-05-23 22:02:0077017172</td>\n","      <td>77017</td>\n","      <td>2735</td>\n","      <td>172</td>\n","      <td>2019-05-23 22:02:00</td>\n","      <td>Lentersweg</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-05-23 22:26:00</td>\n","      <td>1422.0</td>\n","      <td>7817.000000</td>\n","      <td>1440.0</td>\n","      <td>7975.000000</td>\n","    </tr>\n","    <tr>\n","      <th>67424</th>\n","      <td>2019-05-23 22:14:0077047171</td>\n","      <td>77047</td>\n","      <td>1725</td>\n","      <td>171</td>\n","      <td>2019-05-23 22:14:00</td>\n","      <td>U Farmsen</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-05-23 22:40:00</td>\n","      <td>1608.0</td>\n","      <td>8894.333333</td>\n","      <td>1560.0</td>\n","      <td>9116.666667</td>\n","    </tr>\n","    <tr>\n","      <th>67425</th>\n","      <td>2019-05-23 22:41:0077047171</td>\n","      <td>77047</td>\n","      <td>1725</td>\n","      <td>171</td>\n","      <td>2019-05-23 22:41:00</td>\n","      <td>U S Barmbek</td>\n","      <td>U S Barmbek</td>\n","      <td>2019-05-23 22:41:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>67426</th>\n","      <td>2019-05-23 22:46:0077017172</td>\n","      <td>77017</td>\n","      <td>2735</td>\n","      <td>172</td>\n","      <td>2019-05-23 22:46:00</td>\n","      <td>U S Barmbek</td>\n","      <td>Im Grünen Grunde</td>\n","      <td>2019-05-23 22:58:00</td>\n","      <td>720.0</td>\n","      <td>4368.333333</td>\n","      <td>720.0</td>\n","      <td>4441.666667</td>\n","    </tr>\n","    <tr>\n","      <th>67427</th>\n","      <td>2019-05-23 22:59:0077017172</td>\n","      <td>77017</td>\n","      <td>2735</td>\n","      <td>172</td>\n","      <td>2019-05-23 22:59:00</td>\n","      <td>Im Grünen Grunde</td>\n","      <td>Im Grünen Grunde</td>\n","      <td>2019-05-23 22:59:00</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>67428 rows × 12 columns</p>\n","</div>"],"text/plain":["                        JourneyRef    UML  ... Driving_time_s_p   Distance_m_p\n","0       2019-05-01 00:00:007705325  77053  ...          86280.0  378870.000000\n","1      2019-05-01 00:00:0077108172  77108  ...          86280.0    9046.666667\n","2        2019-05-01 00:00:00771097  77109  ...          86340.0    4620.000000\n","3      2019-05-01 00:00:0077113173  77113  ...          86280.0    3618.333333\n","4       2019-05-01 00:00:007711617  77116  ...          86280.0    8176.666667\n","...                            ...    ...  ...              ...            ...\n","67423  2019-05-23 22:02:0077017172  77017  ...           1440.0    7975.000000\n","67424  2019-05-23 22:14:0077047171  77047  ...           1560.0    9116.666667\n","67425  2019-05-23 22:41:0077047171  77047  ...              0.0       0.000000\n","67426  2019-05-23 22:46:0077017172  77017  ...            720.0    4441.666667\n","67427  2019-05-23 22:59:0077017172  77017  ...              0.0       0.000000\n","\n","[67428 rows x 12 columns]"]},"metadata":{"tags":[]},"execution_count":131}]},{"cell_type":"code","metadata":{"id":"Gck7MhtK7rDf","executionInfo":{"status":"ok","timestamp":1604102064950,"user_tz":-60,"elapsed":756,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"fc2aa021-de2f-4749-9915-706d4993ec4d","colab":{"base_uri":"https://localhost:8080/","height":97}},"source":["data.loc[data['JourneyRef']=='2019-05-23 22:59:0077017172']"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>JourneyRef</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Linie</th>\n","      <th>S_Time</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>E_Time</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1040092</th>\n","      <td>2019-05-23 22:59:0077017172</td>\n","      <td>77017</td>\n","      <td>2735</td>\n","      <td>172</td>\n","      <td>2019-05-23 22:59:00</td>\n","      <td>Im Grünen Grunde</td>\n","      <td>Im Grünen Grunde</td>\n","      <td>2019-05-23 22:59:00</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                          JourneyRef    UML  ... Driving_time_s_p Distance_m_p\n","1040092  2019-05-23 22:59:0077017172  77017  ...              0.0          0.0\n","\n","[1 rows x 12 columns]"]},"metadata":{"tags":[]},"execution_count":128}]},{"cell_type":"code","metadata":{"id":"JcjfJ1NlJ4xB"},"source":["# function for aggregate data\n","def aggregate_data(data):\n","    import datetime\n","    newdata = data[data['Fahrplanlage_IST'].notnull()].copy()\n","    newdata['Ab_ZT_PLAN'] = newdata['Ab_ZT_PLAN'].fillna(newdata['Ab_ZT_PLAN'].shift(1))\n","    '''\n","    #fill time at the end of the each trip table to be the same as departure time\n","    newdata['Ank_ZT_PLAN'] = 0\n","    newdata.loc[newdata['Fahrplanlage_IST'].shift(-1)  == 'Fahrplanlage IST', 'Ank_ZT_PLAN'] = newdata['Ab_ZT_PLAN']\n","    newdata.loc[newdata['Fahrplanlage_IST'].shift(-1)  != 'Fahrplanlage IST', 'Ank_ZT_PLAN'] = newdata['Ab_ZT_PLAN'].shift(-1)\n","    newdata['Ank_ZT_PLAN'] = newdata['Ank_ZT_PLAN'].fillna(newdata['Ank_ZT_PLAN'].shift(1))\n","    \n","    #find route name start-end station\n","    newdata['Haltestelle'] = newdata['Haltestelle'].fillna(newdata['Haltestelle'].shift(-1))\n","    #newdata['S_Station'] = \"\"\n","    #newdata['E_Station'] = \"\"\n","    newdata.loc[newdata['Wagen'].notnull(), 'S_Station'] = newdata['Haltestelle']\n","    #newdata.loc[newdata['Fahrplanlage_IST'].shift(1) != 'Fahrplanlage IST', 'S_Station'] = newdata['S_Station'].shift(1)\n","    \n","    newdata.loc[newdata['Wagen'].shift(-1).notnull(), 'E_Station'] = newdata['Haltestelle']\n","    #newdata.loc[newdata['Fahrplanlage_IST'].shift(-1)  != 'Fahrplanlage IST', 'Ank_ZT_PLAN'] = newdata['Ab_ZT_PLAN'].shift(-1)  \n","\n","    #rearrage table and create new column for destination bus station\n","    #newdata = newdata.sort_values(['Wagen', 'Ank_ZT_PLAN'])\n","    #newdata.loc[newdata['Wagen'].shift(1) != newdata['Wagen'], 'NHaltestelle'] = 'Source'\n","    newdata.loc[newdata['Wagen'].shift(-1).isnull(), 'NHaltestelle'] = newdata['Haltestelle'].shift(-1)\n","    #newdata['NHaltestelle'] = newdata['Haltestelle'].shift(-1)\n","    newdata['NHaltestelle'] = newdata['NHaltestelle'].fillna('Source')\n","    newdata['Node A to Node B']= newdata['Haltestelle']+\"|\"+ newdata['NHaltestelle']\n","    \n","    #Fill empty with below value\n","    newdata['E_Station'].fillna(method='bfill', inplace=True)\n","    #Fill empty with above value\n","    newdata.fillna(method='ffill', inplace=True)\n","    #newdata = newdata[newdata['Fahrplanlage_IST']!='Fahrplanlage IST']\n","    newdata['Linie'] = newdata['Linie'].astype(object)\n","    newdata['UML'] = newdata['UML'].astype(object)\n","    newdata['Wagen'] = newdata['Wagen'].astype(object)\n","\n","    #prevent wrong date data\n","    newdata['date'] = newdata['Datum'].astype(str).str[:10].replace('2020.', '2019.', regex=True)\n","    #newdata = newdata.drop('Datum', axis = 1)\n","    \n","           \n","    #change characteristic of departure and arrival\n","    newdata['Ab_ZT_PLAN'] = pd.to_datetime(newdata['date'] + ' ' + newdata['Ab_ZT_PLAN'], format='%d.%m.%Y %H:%M', errors='ignore')\n","    newdata['Ank_ZT_PLAN'] = pd.to_datetime(newdata['date'] + ' ' + newdata['Ank_ZT_PLAN'], format='%d.%m.%Y %H:%M', errors='ignore')\n","    \n","    newdata['Fahrplanlage_IST'] = pd.to_numeric( newdata['Fahrplanlage_IST'].astype(str).replace(',', '', regex = True))\n","    #actual time calculate from minute late\n","    newdata['Ab_ZT_ACTUAL'] = newdata['Ab_ZT_PLAN']+pd.to_timedelta(newdata['Fahrplanlage_IST'], unit='min')\n","    \n","    newdata.loc[newdata['Ab_ZT_PLAN']  == newdata['Ank_ZT_PLAN'], 'Ank_ZT_ACTUAL'] = newdata['Ab_ZT_ACTUAL']\n","    newdata['Ank_ZT_ACTUAL'] = newdata['Ank_ZT_ACTUAL'].fillna(newdata['Ab_ZT_ACTUAL'].shift(-1))\n","    #newdata['Ank_ZT_ACTUAL'] = newdata['Ab_ZT_ACTUAL'].shift(-1)\n","    \n","    #calculate driving time and distance\n","    newdata['Driving_time_s'] = (pd.to_datetime(newdata['Ank_ZT_ACTUAL']) - pd.to_datetime(newdata['Ab_ZT_ACTUAL'])).dt.total_seconds() \n","    newdata['Distance_m'] = pd.to_numeric( newdata['v_IST'].astype(str).replace(',|-', '', regex = True)) * 10/36 * newdata['Driving_time_s']\n","    newdata['Driving_time_s_p'] = (pd.to_datetime(newdata['Ank_ZT_PLAN']) - pd.to_datetime(newdata['Ab_ZT_PLAN'])).dt.total_seconds() \n","    newdata['Distance_m_p'] = pd.to_numeric( newdata['v_PLAN'].astype(str).replace(',|-', '', regex = True)) * 10/36 * newdata['Driving_time_s_p']\n","    '''\n","    return newdata"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"Cq56sVLDKMaV","executionInfo":{"status":"ok","timestamp":1604089111111,"user_tz":-60,"elapsed":3214,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"bcb92bce-a0bc-4b78-94d8-909335190a83","colab":{"base_uri":"https://localhost:8080/"}},"source":["path =r'/content/drive/My Drive/Colab Notebooks/Fahrten BBD BBW 01.03.2019-30.09.2019' # use your path\n","allFiles = glob.glob(path + \"/*.csv\")\n","\n","date_list = [allFile[-15:-5] for allFile in allFiles]\n","#line_list = [allFile[-21:-16] for allFile in allFiles]\n","\n","list_ = []\n","i=0\n","\n","\n","for file_ in allFiles:\n","    df = pd.read_csv(file_, sep=',',skiprows=3,\n","                      names = ['Datum','UML','Wagen','Ab_ZT_PLAN','Linie','Haltestelle','Fahrplanlage_IST','v_PLAN','v_IST_S2S1','v_netto_S2S1','FFVP_GESCHWINDIGKEIT','v_IST'\n","                              ])\n","    #df['date'] = date_list[i]\n","    #df['line'] = line_list[i]\n","\n","    df = aggregate_data(df)\n","    list_.append(df)\n","    i+=1\n","\n","agg_data = pd.concat(list_, axis = 0, ignore_index = True)"],"execution_count":null,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.6/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (6) have mixed types.Specify dtype option on import or set low_memory=False.\n","  interactivity=interactivity, compiler=compiler, result=result)\n"],"name":"stderr"}]},{"cell_type":"code","metadata":{"id":"t83HD7WjKW3p","executionInfo":{"status":"ok","timestamp":1604089206824,"user_tz":-60,"elapsed":1103,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"3fe7a9a5-1260-45dd-9d74-59d3da2c8429","colab":{"base_uri":"https://localhost:8080/","height":1000}},"source":["agg_data[:50]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Datum</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Ab_ZT_PLAN</th>\n","      <th>Linie</th>\n","      <th>Haltestelle</th>\n","      <th>Fahrplanlage_IST</th>\n","      <th>v_PLAN</th>\n","      <th>v_IST_S2S1</th>\n","      <th>v_netto_S2S1</th>\n","      <th>FFVP_GESCHWINDIGKEIT</th>\n","      <th>v_IST</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>01.05.2019</td>\n","      <td>77001.0</td>\n","      <td>7309.0</td>\n","      <td>03:58</td>\n","      <td>25.0</td>\n","      <td>U Burgstraße</td>\n","      <td>0.8</td>\n","      <td>32.8</td>\n","      <td>19.9</td>\n","      <td>17.1</td>\n","      <td>15</td>\n","      <td>15.7</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>03:59</td>\n","      <td>25.0</td>\n","      <td>Carl-Petersen-Straße</td>\n","      <td>2</td>\n","      <td>10.9</td>\n","      <td>655.2</td>\n","      <td>3.6</td>\n","      <td>0</td>\n","      <td>46.8</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:00</td>\n","      <td>25.0</td>\n","      <td>S Landwehr (Ramazan-Avci-Platz)</td>\n","      <td>1.1</td>\n","      <td>24.4</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>30</td>\n","      <td>14.4</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:01</td>\n","      <td>25.0</td>\n","      <td>U Wartenau</td>\n","      <td>1.8</td>\n","      <td>27.8</td>\n","      <td>45.1</td>\n","      <td>39.7</td>\n","      <td>0</td>\n","      <td>39.8</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:02</td>\n","      <td>25.0</td>\n","      <td>Uferstraße</td>\n","      <td>1.5</td>\n","      <td>16.3</td>\n","      <td>46.5</td>\n","      <td>36.5</td>\n","      <td>38</td>\n","      <td>20.3</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:03</td>\n","      <td>25.0</td>\n","      <td>U Mundsburg</td>\n","      <td>1.8</td>\n","      <td>20.0</td>\n","      <td>37.6</td>\n","      <td>33.2</td>\n","      <td>0</td>\n","      <td>20.9</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:05</td>\n","      <td>25.0</td>\n","      <td>Beethovenstraße</td>\n","      <td>1.4</td>\n","      <td>22.0</td>\n","      <td>17.9</td>\n","      <td>15.0</td>\n","      <td>0</td>\n","      <td>14.5</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:10</td>\n","      <td>25.0</td>\n","      <td>Gertigstraße</td>\n","      <td>1.6</td>\n","      <td>27.1</td>\n","      <td>42.7</td>\n","      <td>32.9</td>\n","      <td>0</td>\n","      <td>31.2</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:11</td>\n","      <td>25.0</td>\n","      <td>Goldbekplatz</td>\n","      <td>1.6</td>\n","      <td>25.0</td>\n","      <td>39.5</td>\n","      <td>34.2</td>\n","      <td>2</td>\n","      <td>25.9</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:12</td>\n","      <td>25.0</td>\n","      <td>Dorotheenstraße</td>\n","      <td>1.4</td>\n","      <td>11.6</td>\n","      <td>31.7</td>\n","      <td>27.5</td>\n","      <td>26</td>\n","      <td>23.2</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:14</td>\n","      <td>25.0</td>\n","      <td>U Sierichstraße</td>\n","      <td>0.6</td>\n","      <td>16.5</td>\n","      <td>21.1</td>\n","      <td>18.4</td>\n","      <td>0</td>\n","      <td>16.1</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:16</td>\n","      <td>25.0</td>\n","      <td>Winterhuder Marktplatz</td>\n","      <td>0.6</td>\n","      <td>12.4</td>\n","      <td>53.0</td>\n","      <td>36.0</td>\n","      <td>0</td>\n","      <td>12.6</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:17</td>\n","      <td>25.0</td>\n","      <td>U Hudtwalckerstraße</td>\n","      <td>0.6</td>\n","      <td>14.9</td>\n","      <td>43.4</td>\n","      <td>38.5</td>\n","      <td>0</td>\n","      <td>18.0</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:20</td>\n","      <td>25.0</td>\n","      <td>U Kellinghusenstraße</td>\n","      <td>1.5</td>\n","      <td>15.9</td>\n","      <td>28.3</td>\n","      <td>25.9</td>\n","      <td>0</td>\n","      <td>13.2</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:23</td>\n","      <td>25.0</td>\n","      <td>Eppendorfer Marktplatz</td>\n","      <td>0.7</td>\n","      <td>25.1</td>\n","      <td>18.2</td>\n","      <td>15.3</td>\n","      <td>0</td>\n","      <td>13.7</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:24</td>\n","      <td>25.0</td>\n","      <td>Julius-Reincke-Stieg (Bethanien)</td>\n","      <td>1.5</td>\n","      <td>23.1</td>\n","      <td>42.0</td>\n","      <td>35.3</td>\n","      <td>0</td>\n","      <td>28.9</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:25</td>\n","      <td>25.0</td>\n","      <td>Eppendorfer Park (UKE)</td>\n","      <td>1.2</td>\n","      <td>9.4</td>\n","      <td>51.4</td>\n","      <td>35.0</td>\n","      <td>24</td>\n","      <td>6.1</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:26</td>\n","      <td>25.0</td>\n","      <td>UK Eppendorf</td>\n","      <td>1.8</td>\n","      <td>21.9</td>\n","      <td>45.3</td>\n","      <td>37.4</td>\n","      <td>0</td>\n","      <td>31.3</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:27</td>\n","      <td>25.0</td>\n","      <td>Löwenstraße (Facharztklinik)</td>\n","      <td>1.4</td>\n","      <td>21.2</td>\n","      <td>19.6</td>\n","      <td>15.4</td>\n","      <td>34</td>\n","      <td>11.0</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:28</td>\n","      <td>25.0</td>\n","      <td>Gärtnerstraße</td>\n","      <td>2.5</td>\n","      <td>19.3</td>\n","      <td>22.7</td>\n","      <td>20.2</td>\n","      <td>0</td>\n","      <td>17.9</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:30</td>\n","      <td>25.0</td>\n","      <td>Kottwitzstraße</td>\n","      <td>2.6</td>\n","      <td>15.1</td>\n","      <td>45.2</td>\n","      <td>35.8</td>\n","      <td>0</td>\n","      <td>23.2</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:31</td>\n","      <td>25.0</td>\n","      <td>Goebenstraße</td>\n","      <td>2.2</td>\n","      <td>13.5</td>\n","      <td>60.1</td>\n","      <td>46.8</td>\n","      <td>33</td>\n","      <td>35.3</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:33</td>\n","      <td>25.0</td>\n","      <td>Schulweg</td>\n","      <td>1.2</td>\n","      <td>24.7</td>\n","      <td>42.3</td>\n","      <td>36.7</td>\n","      <td>0</td>\n","      <td>25.5</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:34</td>\n","      <td>25.0</td>\n","      <td>Fruchtallee (Hamburg-Haus)</td>\n","      <td>0.9</td>\n","      <td>20.6</td>\n","      <td>29.4</td>\n","      <td>40.4</td>\n","      <td>32</td>\n","      <td>26.9</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:36</td>\n","      <td>25.0</td>\n","      <td>Alsenplatz</td>\n","      <td>0.4</td>\n","      <td>33.2</td>\n","      <td>199.4</td>\n","      <td>41.8</td>\n","      <td>34</td>\n","      <td>53.9</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:37</td>\n","      <td>25.0</td>\n","      <td>S Holstenstraße</td>\n","      <td>0.2</td>\n","      <td>13.8</td>\n","      <td>33.7</td>\n","      <td>29.4</td>\n","      <td>0</td>\n","      <td>17.8</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:39</td>\n","      <td>25.0</td>\n","      <td>Max-Brauer-Allee (Mitte)</td>\n","      <td>-0.4</td>\n","      <td>27.8</td>\n","      <td>39.8</td>\n","      <td>35.2</td>\n","      <td>7</td>\n","      <td>21.4</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:40</td>\n","      <td>25.0</td>\n","      <td>Gerichtstraße</td>\n","      <td>-0.1</td>\n","      <td>15.7</td>\n","      <td>28.3</td>\n","      <td>24.9</td>\n","      <td>7</td>\n","      <td>24.6</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:43</td>\n","      <td>25.0</td>\n","      <td>Bf. Altona</td>\n","      <td>-1.5</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>-</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>7309.0</td>\n","      <td>04:50</td>\n","      <td>25.0</td>\n","      <td>Bf. Altona</td>\n","      <td>0.7</td>\n","      <td>23.3</td>\n","      <td>26.9</td>\n","      <td>22.0</td>\n","      <td>1</td>\n","      <td>18.8</td>\n","    </tr>\n","    <tr>\n","      <th>30</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:52</td>\n","      <td>25.0</td>\n","      <td>Gerichtstraße</td>\n","      <td>1.1</td>\n","      <td>17.1</td>\n","      <td>18.7</td>\n","      <td>16.8</td>\n","      <td>0</td>\n","      <td>16.4</td>\n","    </tr>\n","    <tr>\n","      <th>31</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:54</td>\n","      <td>25.0</td>\n","      <td>Max-Brauer-Allee (Mitte)</td>\n","      <td>1.1</td>\n","      <td>9.3</td>\n","      <td>39.9</td>\n","      <td>32.9</td>\n","      <td>79</td>\n","      <td>14.5</td>\n","    </tr>\n","    <tr>\n","      <th>32</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>04:56</td>\n","      <td>25.0</td>\n","      <td>S Holstenstraße</td>\n","      <td>0.5</td>\n","      <td>35.3</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>-</td>\n","    </tr>\n","    <tr>\n","      <th>33</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:00</td>\n","      <td>25.0</td>\n","      <td>Schulweg</td>\n","      <td>0.5</td>\n","      <td>14.2</td>\n","      <td>43.7</td>\n","      <td>38.3</td>\n","      <td>9</td>\n","      <td>29.9</td>\n","    </tr>\n","    <tr>\n","      <th>34</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:02</td>\n","      <td>25.0</td>\n","      <td>Goebenstraße</td>\n","      <td>-0.4</td>\n","      <td>20.2</td>\n","      <td>20.2</td>\n","      <td>17.5</td>\n","      <td>0</td>\n","      <td>14.2</td>\n","    </tr>\n","    <tr>\n","      <th>35</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:03</td>\n","      <td>25.0</td>\n","      <td>Kottwitzstraße</td>\n","      <td>0</td>\n","      <td>18.0</td>\n","      <td>42.4</td>\n","      <td>34.9</td>\n","      <td>0</td>\n","      <td>13.8</td>\n","    </tr>\n","    <tr>\n","      <th>36</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:05</td>\n","      <td>25.0</td>\n","      <td>Gärtnerstraße</td>\n","      <td>0.5</td>\n","      <td>22.6</td>\n","      <td>17.8</td>\n","      <td>15.7</td>\n","      <td>10</td>\n","      <td>14.9</td>\n","    </tr>\n","    <tr>\n","      <th>37</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:06</td>\n","      <td>25.0</td>\n","      <td>Löwenstraße (Facharztklinik)</td>\n","      <td>1.2</td>\n","      <td>22.3</td>\n","      <td>43.2</td>\n","      <td>36.6</td>\n","      <td>0</td>\n","      <td>21.6</td>\n","    </tr>\n","    <tr>\n","      <th>38</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:07</td>\n","      <td>25.0</td>\n","      <td>UK Eppendorf</td>\n","      <td>1.2</td>\n","      <td>14.2</td>\n","      <td>42.5</td>\n","      <td>34.0</td>\n","      <td>0</td>\n","      <td>19.3</td>\n","    </tr>\n","    <tr>\n","      <th>39</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:08</td>\n","      <td>25.0</td>\n","      <td>Eppendorfer Park (UKE)</td>\n","      <td>0.9</td>\n","      <td>14.3</td>\n","      <td>42.8</td>\n","      <td>34.9</td>\n","      <td>1</td>\n","      <td>18.6</td>\n","    </tr>\n","    <tr>\n","      <th>40</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:09</td>\n","      <td>25.0</td>\n","      <td>Julius-Reincke-Stieg (Bethanien)</td>\n","      <td>0.6</td>\n","      <td>9.9</td>\n","      <td>15.1</td>\n","      <td>13.1</td>\n","      <td>0</td>\n","      <td>9.0</td>\n","    </tr>\n","    <tr>\n","      <th>41</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:12</td>\n","      <td>25.0</td>\n","      <td>Eppendorfer Marktplatz</td>\n","      <td>0.9</td>\n","      <td>14.3</td>\n","      <td>39.0</td>\n","      <td>35.1</td>\n","      <td>14</td>\n","      <td>29.9</td>\n","    </tr>\n","    <tr>\n","      <th>42</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:15</td>\n","      <td>25.0</td>\n","      <td>U Kellinghusenstraße</td>\n","      <td>1</td>\n","      <td>25.4</td>\n","      <td>28.5</td>\n","      <td>24.6</td>\n","      <td>0</td>\n","      <td>14.2</td>\n","    </tr>\n","    <tr>\n","      <th>43</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:17</td>\n","      <td>25.0</td>\n","      <td>U Hudtwalckerstraße</td>\n","      <td>0.9</td>\n","      <td>8.6</td>\n","      <td>32.2</td>\n","      <td>34.0</td>\n","      <td>23</td>\n","      <td>15.1</td>\n","    </tr>\n","    <tr>\n","      <th>44</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:18</td>\n","      <td>25.0</td>\n","      <td>Winterhuder Marktplatz</td>\n","      <td>0.6</td>\n","      <td>35.5</td>\n","      <td>37.4</td>\n","      <td>33.1</td>\n","      <td>0</td>\n","      <td>26.6</td>\n","    </tr>\n","    <tr>\n","      <th>45</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:19</td>\n","      <td>25.0</td>\n","      <td>U Sierichstraße</td>\n","      <td>0.9</td>\n","      <td>21.1</td>\n","      <td>46.9</td>\n","      <td>39.2</td>\n","      <td>7</td>\n","      <td>25.9</td>\n","    </tr>\n","    <tr>\n","      <th>46</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:20</td>\n","      <td>25.0</td>\n","      <td>Dorotheenstraße</td>\n","      <td>0.6</td>\n","      <td>15.9</td>\n","      <td>35.9</td>\n","      <td>31.5</td>\n","      <td>0</td>\n","      <td>20.5</td>\n","    </tr>\n","    <tr>\n","      <th>47</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:22</td>\n","      <td>25.0</td>\n","      <td>Goldbekplatz</td>\n","      <td>0.3</td>\n","      <td>27.7</td>\n","      <td>47.5</td>\n","      <td>39.5</td>\n","      <td>0</td>\n","      <td>19.3</td>\n","    </tr>\n","    <tr>\n","      <th>48</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:23</td>\n","      <td>25.0</td>\n","      <td>Gertigstraße</td>\n","      <td>0.8</td>\n","      <td>11.2</td>\n","      <td>42.1</td>\n","      <td>29.7</td>\n","      <td>0</td>\n","      <td>21.7</td>\n","    </tr>\n","    <tr>\n","      <th>49</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>05:24</td>\n","      <td>25.0</td>\n","      <td>Mühlenkamp/Hofweg</td>\n","      <td>0.1</td>\n","      <td>21.5</td>\n","      <td>20.8</td>\n","      <td>18.3</td>\n","      <td>34</td>\n","      <td>15.8</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["         Datum      UML   Wagen  ... v_netto_S2S1  FFVP_GESCHWINDIGKEIT v_IST\n","0   01.05.2019  77001.0  7309.0  ...         17.1                    15  15.7\n","1          NaN      NaN     NaN  ...          3.6                     0  46.8\n","2          NaN      NaN     NaN  ...            -                    30  14.4\n","3          NaN      NaN     NaN  ...         39.7                     0  39.8\n","4          NaN      NaN     NaN  ...         36.5                    38  20.3\n","5          NaN      NaN     NaN  ...         33.2                     0  20.9\n","6          NaN      NaN     NaN  ...         15.0                     0  14.5\n","7          NaN      NaN     NaN  ...         32.9                     0  31.2\n","8          NaN      NaN     NaN  ...         34.2                     2  25.9\n","9          NaN      NaN     NaN  ...         27.5                    26  23.2\n","10         NaN      NaN     NaN  ...         18.4                     0  16.1\n","11         NaN      NaN     NaN  ...         36.0                     0  12.6\n","12         NaN      NaN     NaN  ...         38.5                     0  18.0\n","13         NaN      NaN     NaN  ...         25.9                     0  13.2\n","14         NaN      NaN     NaN  ...         15.3                     0  13.7\n","15         NaN      NaN     NaN  ...         35.3                     0  28.9\n","16         NaN      NaN     NaN  ...         35.0                    24   6.1\n","17         NaN      NaN     NaN  ...         37.4                     0  31.3\n","18         NaN      NaN     NaN  ...         15.4                    34  11.0\n","19         NaN      NaN     NaN  ...         20.2                     0  17.9\n","20         NaN      NaN     NaN  ...         35.8                     0  23.2\n","21         NaN      NaN     NaN  ...         46.8                    33  35.3\n","22         NaN      NaN     NaN  ...         36.7                     0  25.5\n","23         NaN      NaN     NaN  ...         40.4                    32  26.9\n","24         NaN      NaN     NaN  ...         41.8                    34  53.9\n","25         NaN      NaN     NaN  ...         29.4                     0  17.8\n","26         NaN      NaN     NaN  ...         35.2                     7  21.4\n","27         NaN      NaN     NaN  ...         24.9                     7  24.6\n","28         NaN      NaN     NaN  ...            -                     0     -\n","29         NaN      NaN  7309.0  ...         22.0                     1  18.8\n","30         NaN      NaN     NaN  ...         16.8                     0  16.4\n","31         NaN      NaN     NaN  ...         32.9                    79  14.5\n","32         NaN      NaN     NaN  ...            -                     0     -\n","33         NaN      NaN     NaN  ...         38.3                     9  29.9\n","34         NaN      NaN     NaN  ...         17.5                     0  14.2\n","35         NaN      NaN     NaN  ...         34.9                     0  13.8\n","36         NaN      NaN     NaN  ...         15.7                    10  14.9\n","37         NaN      NaN     NaN  ...         36.6                     0  21.6\n","38         NaN      NaN     NaN  ...         34.0                     0  19.3\n","39         NaN      NaN     NaN  ...         34.9                     1  18.6\n","40         NaN      NaN     NaN  ...         13.1                     0   9.0\n","41         NaN      NaN     NaN  ...         35.1                    14  29.9\n","42         NaN      NaN     NaN  ...         24.6                     0  14.2\n","43         NaN      NaN     NaN  ...         34.0                    23  15.1\n","44         NaN      NaN     NaN  ...         33.1                     0  26.6\n","45         NaN      NaN     NaN  ...         39.2                     7  25.9\n","46         NaN      NaN     NaN  ...         31.5                     0  20.5\n","47         NaN      NaN     NaN  ...         39.5                     0  19.3\n","48         NaN      NaN     NaN  ...         29.7                     0  21.7\n","49         NaN      NaN     NaN  ...         18.3                    34  15.8\n","\n","[50 rows x 12 columns]"]},"metadata":{"tags":[]},"execution_count":9}]},{"cell_type":"markdown","metadata":{"id":"OqI1PC9Fimjh"},"source":["# Export full data"]},{"cell_type":"code","metadata":{"id":"11tM8KPiil79"},"source":["#data.to_csv('restructured_hochbahn.csv')\n","data.to_csv('IST_19.csv')\n","!cp IST_19.csv \"/content/drive/My Drive/Colab Notebooks/Thesis\""],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"ohUKp1_SqWp5"},"source":["## Filter null value"]},{"cell_type":"code","metadata":{"id":"UumNzGvxqV7U","executionInfo":{"status":"ok","timestamp":1600441369154,"user_tz":-120,"elapsed":31461,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"d14b1e78-203f-4a01-adc5-e22daa45e389","colab":{"base_uri":"https://localhost:8080/","height":609}},"source":["#filter v_IST == null (11416) or v_IST_S2S1 == null (14147)\n","data_ist_fil = data[pd.notna(data.v_IST) & pd.notna(data.v_IST_S2S1)]\n","#filter Distance_m == null or <0 (11621)\n","data_ist_fil = data_ist_fil[pd.notna(data_ist_fil.Distance_m) & data_ist_fil.Distance_m >= 0]\n","#filter Distance_m_p == null or == 0 (12799)\n","data_ist_fil = data_ist_fil[pd.notna(data_ist_fil.Distance_m_p) & data_ist_fil.Distance_m_p != 0]\n","data_ist_fil"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Datum</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Ab_ZT_PLAN</th>\n","      <th>Linie</th>\n","      <th>Haltestelle</th>\n","      <th>Fahrplanlage_IST</th>\n","      <th>v_PLAN</th>\n","      <th>v_IST_S2S1</th>\n","      <th>v_netto_S2S1</th>\n","      <th>FFVP_GESCHWINDIGKEIT</th>\n","      <th>v_IST</th>\n","      <th>Ank_ZT_PLAN</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>NHaltestelle</th>\n","      <th>Node A to Node B</th>\n","      <th>date</th>\n","      <th>Ab_ZT_ACTUAL</th>\n","      <th>Ank_ZT_ACTUAL</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>01.05.2019</td>\n","      <td>88001</td>\n","      <td>1506</td>\n","      <td>2019-05-01 04:06:00</td>\n","      <td>171</td>\n","      <td>U Farmsen</td>\n","      <td>-0.1</td>\n","      <td>19.0</td>\n","      <td>12.9</td>\n","      <td>10.4</td>\n","      <td>23</td>\n","      <td>12.1</td>\n","      <td>2019-05-01 04:07:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Eissporthalle</td>\n","      <td>U Farmsen|Eissporthalle</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:05:54</td>\n","      <td>2019-05-01 04:07:24</td>\n","      <td>90.0</td>\n","      <td>302.500000</td>\n","      <td>60.0</td>\n","      <td>316.666667</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>01.05.2019</td>\n","      <td>88001</td>\n","      <td>1506</td>\n","      <td>2019-05-01 04:07:00</td>\n","      <td>171</td>\n","      <td>Eissporthalle</td>\n","      <td>0.4</td>\n","      <td>25.3</td>\n","      <td>47.4</td>\n","      <td>42.5</td>\n","      <td>35</td>\n","      <td>41.0</td>\n","      <td>2019-05-01 04:08:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Eckerkoppel</td>\n","      <td>Eissporthalle|Eckerkoppel</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:07:24</td>\n","      <td>2019-05-01 04:08:06</td>\n","      <td>42.0</td>\n","      <td>478.333333</td>\n","      <td>60.0</td>\n","      <td>421.666667</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>01.05.2019</td>\n","      <td>88001</td>\n","      <td>1506</td>\n","      <td>2019-05-01 04:08:00</td>\n","      <td>171</td>\n","      <td>Eckerkoppel</td>\n","      <td>0.1</td>\n","      <td>36.1</td>\n","      <td>49.2</td>\n","      <td>45.2</td>\n","      <td>35</td>\n","      <td>44.2</td>\n","      <td>2019-05-01 04:09:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Ebeersreye</td>\n","      <td>Eckerkoppel|Ebeersreye</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:08:06</td>\n","      <td>2019-05-01 04:08:54</td>\n","      <td>48.0</td>\n","      <td>589.333333</td>\n","      <td>60.0</td>\n","      <td>601.666667</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>01.05.2019</td>\n","      <td>88001</td>\n","      <td>1506</td>\n","      <td>2019-05-01 04:09:00</td>\n","      <td>171</td>\n","      <td>Ebeersreye</td>\n","      <td>-0.1</td>\n","      <td>20.1</td>\n","      <td>14.3</td>\n","      <td>13.2</td>\n","      <td>38</td>\n","      <td>13.9</td>\n","      <td>2019-05-01 04:11:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>Ebeersreye|Rentenversicherung Nord</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:08:54</td>\n","      <td>2019-05-01 04:11:48</td>\n","      <td>174.0</td>\n","      <td>671.833333</td>\n","      <td>120.0</td>\n","      <td>670.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>01.05.2019</td>\n","      <td>88001</td>\n","      <td>1506</td>\n","      <td>2019-05-01 04:11:00</td>\n","      <td>171</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>0.8</td>\n","      <td>19.1</td>\n","      <td>47.9</td>\n","      <td>41.4</td>\n","      <td>45</td>\n","      <td>30.2</td>\n","      <td>2019-05-01 04:12:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Sylter Weg</td>\n","      <td>Rentenversicherung Nord|Sylter Weg</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:11:48</td>\n","      <td>2019-05-01 04:12:30</td>\n","      <td>42.0</td>\n","      <td>352.333333</td>\n","      <td>60.0</td>\n","      <td>318.333333</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>22048748</th>\n","      <td>24.10.2019</td>\n","      <td>77279</td>\n","      <td>1934</td>\n","      <td>2019-10-24 16:24:00</td>\n","      <td>172</td>\n","      <td>U Mundsburg</td>\n","      <td>0.2</td>\n","      <td>22.5</td>\n","      <td>29.3</td>\n","      <td>25.1</td>\n","      <td>0</td>\n","      <td>18.2</td>\n","      <td>2019-10-24 16:25:00</td>\n","      <td>Lentersweg</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Uferstraße</td>\n","      <td>U Mundsburg|Uferstraße</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:24:12</td>\n","      <td>2019-10-24 16:25:24</td>\n","      <td>72.0</td>\n","      <td>364.000000</td>\n","      <td>60.0</td>\n","      <td>375.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048749</th>\n","      <td>24.10.2019</td>\n","      <td>77279</td>\n","      <td>1934</td>\n","      <td>2019-10-24 16:25:00</td>\n","      <td>172</td>\n","      <td>Uferstraße</td>\n","      <td>0.4</td>\n","      <td>28.5</td>\n","      <td>38.0</td>\n","      <td>34.1</td>\n","      <td>0</td>\n","      <td>30.0</td>\n","      <td>2019-10-24 16:26:00</td>\n","      <td>Lentersweg</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>U Uhlandstraße</td>\n","      <td>Uferstraße|U Uhlandstraße</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:25:24</td>\n","      <td>2019-10-24 16:26:12</td>\n","      <td>48.0</td>\n","      <td>400.000000</td>\n","      <td>60.0</td>\n","      <td>475.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048750</th>\n","      <td>24.10.2019</td>\n","      <td>77279</td>\n","      <td>1934</td>\n","      <td>2019-10-24 16:26:00</td>\n","      <td>172</td>\n","      <td>U Uhlandstraße</td>\n","      <td>0.2</td>\n","      <td>7.7</td>\n","      <td>18.8</td>\n","      <td>15.0</td>\n","      <td>27</td>\n","      <td>16.2</td>\n","      <td>2019-10-24 16:29:00</td>\n","      <td>Lentersweg</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>U Uhlandstraße|Mundsburger Brücke</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:26:12</td>\n","      <td>2019-10-24 16:27:24</td>\n","      <td>72.0</td>\n","      <td>324.000000</td>\n","      <td>180.0</td>\n","      <td>385.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048752</th>\n","      <td>24.10.2019</td>\n","      <td>77279</td>\n","      <td>1934</td>\n","      <td>2019-10-24 16:39:00</td>\n","      <td>173</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>0.3</td>\n","      <td>12.4</td>\n","      <td>15.3</td>\n","      <td>13.8</td>\n","      <td>0</td>\n","      <td>8.8</td>\n","      <td>2019-10-24 16:42:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>U Mundsburg</td>\n","      <td>Mundsburger Brücke|U Mundsburg</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:39:18</td>\n","      <td>2019-10-24 16:43:48</td>\n","      <td>270.0</td>\n","      <td>660.000000</td>\n","      <td>180.0</td>\n","      <td>620.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048753</th>\n","      <td>24.10.2019</td>\n","      <td>77279</td>\n","      <td>1934</td>\n","      <td>2019-10-24 16:42:00</td>\n","      <td>173</td>\n","      <td>U Mundsburg</td>\n","      <td>1.8</td>\n","      <td>39.6</td>\n","      <td>16.7</td>\n","      <td>14.9</td>\n","      <td>0</td>\n","      <td>12.4</td>\n","      <td>2019-10-24 16:43:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Beethovenstraße</td>\n","      <td>U Mundsburg|Beethovenstraße</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:43:48</td>\n","      <td>2019-10-24 16:46:42</td>\n","      <td>174.0</td>\n","      <td>599.333333</td>\n","      <td>60.0</td>\n","      <td>660.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>20832231 rows × 24 columns</p>\n","</div>"],"text/plain":["               Datum    UML Wagen  ...  Distance_m Driving_time_s_p Distance_m_p\n","0         01.05.2019  88001  1506  ...  302.500000             60.0   316.666667\n","1         01.05.2019  88001  1506  ...  478.333333             60.0   421.666667\n","2         01.05.2019  88001  1506  ...  589.333333             60.0   601.666667\n","3         01.05.2019  88001  1506  ...  671.833333            120.0   670.000000\n","4         01.05.2019  88001  1506  ...  352.333333             60.0   318.333333\n","...              ...    ...   ...  ...         ...              ...          ...\n","22048748  24.10.2019  77279  1934  ...  364.000000             60.0   375.000000\n","22048749  24.10.2019  77279  1934  ...  400.000000             60.0   475.000000\n","22048750  24.10.2019  77279  1934  ...  324.000000            180.0   385.000000\n","22048752  24.10.2019  77279  1934  ...  660.000000            180.0   620.000000\n","22048753  24.10.2019  77279  1934  ...  599.333333             60.0   660.000000\n","\n","[20832231 rows x 24 columns]"]},"metadata":{"tags":[]},"execution_count":6}]},{"cell_type":"markdown","metadata":{"id":"7gA9dWreqfiY"},"source":["## Export data"]},{"cell_type":"code","metadata":{"id":"iSb1PYZNqTjZ"},"source":["#data.to_csv('restructured_hochbahn.csv')\n","data_ist_fil.to_csv('IST_filter_19.csv')\n","!cp IST_filter_19.csv \"/content/drive/My Drive/Colab Notebooks/Thesis\""],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"exeC8SvwtqDU"},"source":["# Import to filter line 28"]},{"cell_type":"code","metadata":{"id":"u-SQTlyHVSAL","executionInfo":{"status":"ok","timestamp":1602804858015,"user_tz":-120,"elapsed":168073,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"9fc273fe-9a96-4cd5-9227-d8f2f77cfb0e","colab":{"base_uri":"https://localhost:8080/","height":71}},"source":["data_ist_fil = pd.read_csv('/content/drive/My Drive/Colab Notebooks/Thesis/IST_filter_19.csv', sep=',',skiprows=3,\n","                      names = ['Datum','UML','Wagen','Ab_ZT_PLAN','Linie',\n","                               'Haltestelle','Fahrplanlage_IST','v_PLAN',\n","                               'v_IST_S2S1','v_netto_S2S1','FFVP_GESCHWINDIGKEIT',\n","                               'v_IST', 'Ank_ZT_PLAN', 'S_Station',\t'E_Station',\n","                               'NHaltestelle',\t'Node A to Node B',\t'date',\t\n","                               'Ab_ZT_ACTUAL',\t'Ank_ZT_ACTUAL',\t'Driving_time_s',\t\n","                               'Distance_m',\t'Driving_time_s_p',\t'Distance_m_p'\n","                              ])"],"execution_count":null,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.6/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (5,11) have mixed types.Specify dtype option on import or set low_memory=False.\n","  interactivity=interactivity, compiler=compiler, result=result)\n"],"name":"stderr"}]},{"cell_type":"code","metadata":{"id":"hdxT5584WXDc","executionInfo":{"status":"ok","timestamp":1602804858766,"user_tz":-120,"elapsed":162966,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"ce807c26-3df9-44cf-d8c1-3b96cf36c6bf","colab":{"base_uri":"https://localhost:8080/","height":609}},"source":["data_ist_fil"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Datum</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Ab_ZT_PLAN</th>\n","      <th>Linie</th>\n","      <th>Haltestelle</th>\n","      <th>Fahrplanlage_IST</th>\n","      <th>v_PLAN</th>\n","      <th>v_IST_S2S1</th>\n","      <th>v_netto_S2S1</th>\n","      <th>FFVP_GESCHWINDIGKEIT</th>\n","      <th>v_IST</th>\n","      <th>Ank_ZT_PLAN</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>NHaltestelle</th>\n","      <th>Node A to Node B</th>\n","      <th>date</th>\n","      <th>Ab_ZT_ACTUAL</th>\n","      <th>Ank_ZT_ACTUAL</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:08:00</td>\n","      <td>171</td>\n","      <td>Eckerkoppel</td>\n","      <td>0.1</td>\n","      <td>36.1</td>\n","      <td>49.2</td>\n","      <td>45.2</td>\n","      <td>35</td>\n","      <td>44.2</td>\n","      <td>2019-05-01 04:09:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Ebeersreye</td>\n","      <td>Eckerkoppel|Ebeersreye</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:08:06</td>\n","      <td>2019-05-01 04:08:54</td>\n","      <td>48.0</td>\n","      <td>589.333333</td>\n","      <td>60.0</td>\n","      <td>601.666667</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:09:00</td>\n","      <td>171</td>\n","      <td>Ebeersreye</td>\n","      <td>-0.1</td>\n","      <td>20.1</td>\n","      <td>14.3</td>\n","      <td>13.2</td>\n","      <td>38</td>\n","      <td>13.9</td>\n","      <td>2019-05-01 04:11:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>Ebeersreye|Rentenversicherung Nord</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:08:54</td>\n","      <td>2019-05-01 04:11:48</td>\n","      <td>174.0</td>\n","      <td>671.833333</td>\n","      <td>120.0</td>\n","      <td>670.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:11:00</td>\n","      <td>171</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>0.8</td>\n","      <td>19.1</td>\n","      <td>47.9</td>\n","      <td>41.4</td>\n","      <td>45</td>\n","      <td>30.2</td>\n","      <td>2019-05-01 04:12:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Sylter Weg</td>\n","      <td>Rentenversicherung Nord|Sylter Weg</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:11:48</td>\n","      <td>2019-05-01 04:12:30</td>\n","      <td>42.0</td>\n","      <td>352.333333</td>\n","      <td>60.0</td>\n","      <td>318.333333</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:12:00</td>\n","      <td>171</td>\n","      <td>Sylter Weg</td>\n","      <td>0.5</td>\n","      <td>28.4</td>\n","      <td>18.5</td>\n","      <td>16.2</td>\n","      <td>0</td>\n","      <td>16.3</td>\n","      <td>2019-05-01 04:13:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Am Stadtrand</td>\n","      <td>Sylter Weg|Am Stadtrand</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:12:30</td>\n","      <td>2019-05-01 04:14:06</td>\n","      <td>96.0</td>\n","      <td>434.666667</td>\n","      <td>60.0</td>\n","      <td>473.333333</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:13:00</td>\n","      <td>171</td>\n","      <td>Am Stadtrand</td>\n","      <td>1.1</td>\n","      <td>21.2</td>\n","      <td>50.8</td>\n","      <td>44.5</td>\n","      <td>43</td>\n","      <td>43.8</td>\n","      <td>2019-05-01 04:14:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Helbingtwiete</td>\n","      <td>Am Stadtrand|Helbingtwiete</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:14:06</td>\n","      <td>2019-05-01 04:14:36</td>\n","      <td>30.0</td>\n","      <td>365.000000</td>\n","      <td>60.0</td>\n","      <td>353.333333</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>22048748</th>\n","      <td>24.10.2019</td>\n","      <td>77279.0</td>\n","      <td>1934.0</td>\n","      <td>2019-10-24 16:24:00</td>\n","      <td>172</td>\n","      <td>U Mundsburg</td>\n","      <td>0.2</td>\n","      <td>22.5</td>\n","      <td>29.3</td>\n","      <td>25.1</td>\n","      <td>0</td>\n","      <td>18.2</td>\n","      <td>2019-10-24 16:25:00</td>\n","      <td>Lentersweg</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Uferstraße</td>\n","      <td>U Mundsburg|Uferstraße</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:24:12</td>\n","      <td>2019-10-24 16:25:24</td>\n","      <td>72.0</td>\n","      <td>364.000000</td>\n","      <td>60.0</td>\n","      <td>375.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048749</th>\n","      <td>24.10.2019</td>\n","      <td>77279.0</td>\n","      <td>1934.0</td>\n","      <td>2019-10-24 16:25:00</td>\n","      <td>172</td>\n","      <td>Uferstraße</td>\n","      <td>0.4</td>\n","      <td>28.5</td>\n","      <td>38.0</td>\n","      <td>34.1</td>\n","      <td>0</td>\n","      <td>30.0</td>\n","      <td>2019-10-24 16:26:00</td>\n","      <td>Lentersweg</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>U Uhlandstraße</td>\n","      <td>Uferstraße|U Uhlandstraße</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:25:24</td>\n","      <td>2019-10-24 16:26:12</td>\n","      <td>48.0</td>\n","      <td>400.000000</td>\n","      <td>60.0</td>\n","      <td>475.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048750</th>\n","      <td>24.10.2019</td>\n","      <td>77279.0</td>\n","      <td>1934.0</td>\n","      <td>2019-10-24 16:26:00</td>\n","      <td>172</td>\n","      <td>U Uhlandstraße</td>\n","      <td>0.2</td>\n","      <td>7.7</td>\n","      <td>18.8</td>\n","      <td>15.0</td>\n","      <td>27</td>\n","      <td>16.2</td>\n","      <td>2019-10-24 16:29:00</td>\n","      <td>Lentersweg</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>U Uhlandstraße|Mundsburger Brücke</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:26:12</td>\n","      <td>2019-10-24 16:27:24</td>\n","      <td>72.0</td>\n","      <td>324.000000</td>\n","      <td>180.0</td>\n","      <td>385.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048752</th>\n","      <td>24.10.2019</td>\n","      <td>77279.0</td>\n","      <td>1934.0</td>\n","      <td>2019-10-24 16:39:00</td>\n","      <td>173</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>0.3</td>\n","      <td>12.4</td>\n","      <td>15.3</td>\n","      <td>13.8</td>\n","      <td>0</td>\n","      <td>8.8</td>\n","      <td>2019-10-24 16:42:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>U Mundsburg</td>\n","      <td>Mundsburger Brücke|U Mundsburg</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:39:18</td>\n","      <td>2019-10-24 16:43:48</td>\n","      <td>270.0</td>\n","      <td>660.000000</td>\n","      <td>180.0</td>\n","      <td>620.000000</td>\n","    </tr>\n","    <tr>\n","      <th>22048753</th>\n","      <td>24.10.2019</td>\n","      <td>77279.0</td>\n","      <td>1934.0</td>\n","      <td>2019-10-24 16:42:00</td>\n","      <td>173</td>\n","      <td>U Mundsburg</td>\n","      <td>1.8</td>\n","      <td>39.6</td>\n","      <td>16.7</td>\n","      <td>14.9</td>\n","      <td>0</td>\n","      <td>12.4</td>\n","      <td>2019-10-24 16:43:00</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Mundsburger Brücke</td>\n","      <td>Beethovenstraße</td>\n","      <td>U Mundsburg|Beethovenstraße</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 16:43:48</td>\n","      <td>2019-10-24 16:46:42</td>\n","      <td>174.0</td>\n","      <td>599.333333</td>\n","      <td>60.0</td>\n","      <td>660.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>20832229 rows × 24 columns</p>\n","</div>"],"text/plain":["               Datum      UML  ...  Driving_time_s_p Distance_m_p\n","2         01.05.2019  88001.0  ...              60.0   601.666667\n","3         01.05.2019  88001.0  ...             120.0   670.000000\n","4         01.05.2019  88001.0  ...              60.0   318.333333\n","5         01.05.2019  88001.0  ...              60.0   473.333333\n","6         01.05.2019  88001.0  ...              60.0   353.333333\n","...              ...      ...  ...               ...          ...\n","22048748  24.10.2019  77279.0  ...              60.0   375.000000\n","22048749  24.10.2019  77279.0  ...              60.0   475.000000\n","22048750  24.10.2019  77279.0  ...             180.0   385.000000\n","22048752  24.10.2019  77279.0  ...             180.0   620.000000\n","22048753  24.10.2019  77279.0  ...              60.0   660.000000\n","\n","[20832229 rows x 24 columns]"]},"metadata":{"tags":[]},"execution_count":4}]},{"cell_type":"code","metadata":{"id":"9Vws__88WaXj","executionInfo":{"status":"ok","timestamp":1600854582473,"user_tz":-120,"elapsed":704,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"9a3fe30e-9768-4955-a5c9-c6092a3acc6e","colab":{"base_uri":"https://localhost:8080/","height":711}},"source":["#filter ONLY LINE 28\n","data_ist_fil = data_ist_fil[data_ist_fil.Linie == 28].reset_index()\n","data_ist_fil"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>index</th>\n","      <th>Datum</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Ab_ZT_PLAN</th>\n","      <th>Linie</th>\n","      <th>Haltestelle</th>\n","      <th>Fahrplanlage_IST</th>\n","      <th>v_PLAN</th>\n","      <th>v_IST_S2S1</th>\n","      <th>v_netto_S2S1</th>\n","      <th>FFVP_GESCHWINDIGKEIT</th>\n","      <th>v_IST</th>\n","      <th>Ank_ZT_PLAN</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>NHaltestelle</th>\n","      <th>Node A to Node B</th>\n","      <th>date</th>\n","      <th>Ab_ZT_ACTUAL</th>\n","      <th>Ank_ZT_ACTUAL</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1588</td>\n","      <td>01.05.2019</td>\n","      <td>88008.0</td>\n","      <td>1772.0</td>\n","      <td>2019-05-01 09:41:00</td>\n","      <td>28</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>0.5</td>\n","      <td>18.9</td>\n","      <td>12.8</td>\n","      <td>11.9</td>\n","      <td>15</td>\n","      <td>12.2</td>\n","      <td>2019-05-01 09:44:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Wandsbek Markt|Wandsbeker Allee</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 09:41:30</td>\n","      <td>2019-05-01 09:46:18</td>\n","      <td>288.0</td>\n","      <td>976.000000</td>\n","      <td>180.0</td>\n","      <td>945.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1589</td>\n","      <td>01.05.2019</td>\n","      <td>88008.0</td>\n","      <td>1772.0</td>\n","      <td>2019-05-01 09:44:00</td>\n","      <td>28</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>2.3</td>\n","      <td>10.7</td>\n","      <td>17.1</td>\n","      <td>17.1</td>\n","      <td>0</td>\n","      <td>12.6</td>\n","      <td>2019-05-01 09:46:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Straßburger Straße</td>\n","      <td>Wandsbeker Allee|U Straßburger Straße</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 09:46:18</td>\n","      <td>2019-05-01 09:48:00</td>\n","      <td>102.0</td>\n","      <td>357.000000</td>\n","      <td>120.0</td>\n","      <td>356.666667</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>1590</td>\n","      <td>01.05.2019</td>\n","      <td>88008.0</td>\n","      <td>1772.0</td>\n","      <td>2019-05-01 09:46:00</td>\n","      <td>28</td>\n","      <td>U Straßburger Straße</td>\n","      <td>2.0</td>\n","      <td>31.4</td>\n","      <td>33.7</td>\n","      <td>25.6</td>\n","      <td>0</td>\n","      <td>14.1</td>\n","      <td>2019-05-01 09:47:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Alter Teichweg</td>\n","      <td>U Straßburger Straße|U Alter Teichweg</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 09:48:00</td>\n","      <td>2019-05-01 09:50:18</td>\n","      <td>138.0</td>\n","      <td>540.500000</td>\n","      <td>60.0</td>\n","      <td>523.333333</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>1591</td>\n","      <td>01.05.2019</td>\n","      <td>88008.0</td>\n","      <td>1772.0</td>\n","      <td>2019-05-01 09:47:00</td>\n","      <td>28</td>\n","      <td>U Alter Teichweg</td>\n","      <td>3.3</td>\n","      <td>28.6</td>\n","      <td>32.7</td>\n","      <td>29.7</td>\n","      <td>0</td>\n","      <td>27.0</td>\n","      <td>2019-05-01 09:49:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Alter Teichweg|Habichtstraße (Mitte)</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 09:50:18</td>\n","      <td>2019-05-01 09:52:12</td>\n","      <td>114.0</td>\n","      <td>855.000000</td>\n","      <td>120.0</td>\n","      <td>953.333333</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1592</td>\n","      <td>01.05.2019</td>\n","      <td>88008.0</td>\n","      <td>1772.0</td>\n","      <td>2019-05-01 09:49:00</td>\n","      <td>28</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>3.2</td>\n","      <td>11.3</td>\n","      <td>24.3</td>\n","      <td>9.3</td>\n","      <td>40</td>\n","      <td>14.2</td>\n","      <td>2019-05-01 09:50:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Habichtstraße</td>\n","      <td>Habichtstraße (Mitte)|U Habichtstraße</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 09:52:12</td>\n","      <td>2019-05-01 09:53:12</td>\n","      <td>60.0</td>\n","      <td>236.666667</td>\n","      <td>60.0</td>\n","      <td>188.333333</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>673736</th>\n","      <td>22038712</td>\n","      <td>24.10.2019</td>\n","      <td>77200.0</td>\n","      <td>1612.0</td>\n","      <td>2019-10-24 18:53:00</td>\n","      <td>28</td>\n","      <td>U Habichtstraße</td>\n","      <td>14.7</td>\n","      <td>19.8</td>\n","      <td>4.7</td>\n","      <td>3.8</td>\n","      <td>0</td>\n","      <td>4.1</td>\n","      <td>2019-10-24 18:54:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Habichtstraße|Habichtstraße (Mitte)</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 19:07:42</td>\n","      <td>2019-10-24 19:12:18</td>\n","      <td>276.0</td>\n","      <td>314.333333</td>\n","      <td>60.0</td>\n","      <td>330.000000</td>\n","    </tr>\n","    <tr>\n","      <th>673737</th>\n","      <td>22038713</td>\n","      <td>24.10.2019</td>\n","      <td>77200.0</td>\n","      <td>1612.0</td>\n","      <td>2019-10-24 18:54:00</td>\n","      <td>28</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>18.3</td>\n","      <td>16.1</td>\n","      <td>7.4</td>\n","      <td>6.9</td>\n","      <td>0</td>\n","      <td>6.7</td>\n","      <td>2019-10-24 18:57:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Alter Teichweg</td>\n","      <td>Habichtstraße (Mitte)|U Alter Teichweg</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 19:12:18</td>\n","      <td>2019-10-24 19:19:42</td>\n","      <td>444.0</td>\n","      <td>826.333333</td>\n","      <td>180.0</td>\n","      <td>805.000000</td>\n","    </tr>\n","    <tr>\n","      <th>673738</th>\n","      <td>22038714</td>\n","      <td>24.10.2019</td>\n","      <td>77200.0</td>\n","      <td>1612.0</td>\n","      <td>2019-10-24 18:57:00</td>\n","      <td>28</td>\n","      <td>U Alter Teichweg</td>\n","      <td>22.7</td>\n","      <td>20.9</td>\n","      <td>8.6</td>\n","      <td>6.8</td>\n","      <td>0</td>\n","      <td>6.9</td>\n","      <td>2019-10-24 18:59:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Straßburger Straße</td>\n","      <td>U Alter Teichweg|U Straßburger Straße</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 19:19:42</td>\n","      <td>2019-10-24 19:25:30</td>\n","      <td>348.0</td>\n","      <td>667.000000</td>\n","      <td>120.0</td>\n","      <td>696.666667</td>\n","    </tr>\n","    <tr>\n","      <th>673739</th>\n","      <td>22038715</td>\n","      <td>24.10.2019</td>\n","      <td>77200.0</td>\n","      <td>1612.0</td>\n","      <td>2019-10-24 18:59:00</td>\n","      <td>28</td>\n","      <td>U Straßburger Straße</td>\n","      <td>26.5</td>\n","      <td>18.1</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>19</td>\n","      <td>11.9</td>\n","      <td>2019-10-24 19:00:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Straßburger Straße|Wandsbeker Allee</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 19:25:30</td>\n","      <td>2019-10-24 19:27:00</td>\n","      <td>90.0</td>\n","      <td>297.500000</td>\n","      <td>60.0</td>\n","      <td>301.666667</td>\n","    </tr>\n","    <tr>\n","      <th>673740</th>\n","      <td>22038716</td>\n","      <td>24.10.2019</td>\n","      <td>77200.0</td>\n","      <td>1612.0</td>\n","      <td>2019-10-24 19:00:00</td>\n","      <td>28</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>27.0</td>\n","      <td>19.4</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>34</td>\n","      <td>-</td>\n","      <td>2019-10-24 12:47:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Source</td>\n","      <td>Wandsbeker Allee|Source</td>\n","      <td>24.10.2019</td>\n","      <td>2019-10-24 19:27:00</td>\n","      <td>2019-10-24 12:47:42</td>\n","      <td>-23958.0</td>\n","      <td>NaN</td>\n","      <td>-22380.0</td>\n","      <td>-120603.333333</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>673741 rows × 25 columns</p>\n","</div>"],"text/plain":["           index       Datum  ...  Driving_time_s_p   Distance_m_p\n","0           1588  01.05.2019  ...             180.0     945.000000\n","1           1589  01.05.2019  ...             120.0     356.666667\n","2           1590  01.05.2019  ...              60.0     523.333333\n","3           1591  01.05.2019  ...             120.0     953.333333\n","4           1592  01.05.2019  ...              60.0     188.333333\n","...          ...         ...  ...               ...            ...\n","673736  22038712  24.10.2019  ...              60.0     330.000000\n","673737  22038713  24.10.2019  ...             180.0     805.000000\n","673738  22038714  24.10.2019  ...             120.0     696.666667\n","673739  22038715  24.10.2019  ...              60.0     301.666667\n","673740  22038716  24.10.2019  ...          -22380.0 -120603.333333\n","\n","[673741 rows x 25 columns]"]},"metadata":{"tags":[]},"execution_count":8}]},{"cell_type":"code","metadata":{"id":"tAK4N9zYXl6q"},"source":["#data.to_csv('restructured_hochbahn.csv')\n","data_ist_fil.to_csv('IST_filter_Line28.csv')\n","!cp IST_filter_Line28.csv \"/content/drive/My Drive/Colab Notebooks/Thesis\""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"Q_7YPXU_X2fe","executionInfo":{"status":"error","timestamp":1601414836280,"user_tz":-120,"elapsed":583,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"8ae467a5-b224-444f-cb2c-d6a0efb56022","colab":{"base_uri":"https://localhost:8080/"}},"source":["data_ist_fil = pd.read_csv('/content/drive/My Drive/Colab Notebooks/Thesis/IST_filter_Line28.csv', sep=',',skiprows=3,\n","                      names = ['Datum','UML','Wagen','Ab_ZT_PLAN','Linie',\n","                               'Haltestelle','Fahrplanlage_IST','v_PLAN',\n","                               'v_IST_S2S1','v_netto_S2S1','FFVP_GESCHWINDIGKEIT',\n","                               'v_IST', 'Ank_ZT_PLAN', 'S_Station',\t'E_Station',\n","                               'NHaltestelle',\t'Node A to Node B',\t'date',\t\n","                               'Ab_ZT_ACTUAL',\t'Ank_ZT_ACTUAL',\t'Driving_time_s',\t\n","                               'Distance_m',\t'Driving_time_s_p',\t'Distance_m_p'\n","                              ])"],"execution_count":null,"outputs":[{"output_type":"error","ename":"NameError","evalue":"ignored","traceback":["\u001b[0;31m---------------------------------------------------------------------------\u001b[0m","\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)","\u001b[0;32m<ipython-input-1-6af9bc99a7ef>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m data_ist_fil = pd.read_csv('/content/drive/My Drive/Colab Notebooks/Thesis/IST_filter_Line28.csv', sep=',',skiprows=3,\n\u001b[0m\u001b[1;32m      2\u001b[0m                       names = ['Datum','UML','Wagen','Ab_ZT_PLAN','Linie',\n\u001b[1;32m      3\u001b[0m                                \u001b[0;34m'Haltestelle'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'Fahrplanlage_IST'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'v_PLAN'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m                                \u001b[0;34m'v_IST_S2S1'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'v_netto_S2S1'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'FFVP_GESCHWINDIGKEIT'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m                                \u001b[0;34m'v_IST'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'Ank_ZT_PLAN'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'S_Station'\u001b[0m\u001b[0;34m,\u001b[0m     \u001b[0;34m'E_Station'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n","\u001b[0;31mNameError\u001b[0m: name 'pd' is not defined"]}]},{"cell_type":"code","metadata":{"id":"2YxeHWGWt0AN","executionInfo":{"status":"ok","timestamp":1601253429254,"user_tz":-120,"elapsed":550,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"3e7bd27f-6db8-4f80-c9d9-2c4d73e802ba","colab":{"base_uri":"https://localhost:8080/","height":1000}},"source":["data_ist_fil.loc[(data_ist_fil['date']=='13.03.2019') & (data_ist_fil['UML']==88094)][100:150]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th></th>\n","      <th>Datum</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Ab_ZT_PLAN</th>\n","      <th>Linie</th>\n","      <th>Haltestelle</th>\n","      <th>Fahrplanlage_IST</th>\n","      <th>v_PLAN</th>\n","      <th>v_IST_S2S1</th>\n","      <th>v_netto_S2S1</th>\n","      <th>FFVP_GESCHWINDIGKEIT</th>\n","      <th>v_IST</th>\n","      <th>Ank_ZT_PLAN</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>NHaltestelle</th>\n","      <th>Node A to Node B</th>\n","      <th>date</th>\n","      <th>Ab_ZT_ACTUAL</th>\n","      <th>Ank_ZT_ACTUAL</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>230868</th>\n","      <th>7887840</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:20:00</td>\n","      <td>28.0</td>\n","      <td>U Straßburger Straße</td>\n","      <td>9.2</td>\n","      <td>17.2</td>\n","      <td>32.2</td>\n","      <td>27.3</td>\n","      <td>0</td>\n","      <td>19.4</td>\n","      <td>2019-03-13 10:21:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Straßburger Straße|Wandsbeker Allee</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 10:29:12</td>\n","      <td>2019-03-13 10:30:06</td>\n","      <td>54.0</td>\n","      <td>291.000000</td>\n","      <td>60.0</td>\n","      <td>286.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230869</th>\n","      <th>7887841</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:21:00</td>\n","      <td>28.0</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>9.1</td>\n","      <td>18.1</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>14.5</td>\n","      <td>2019-03-13 10:47:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Source</td>\n","      <td>Wandsbeker Allee|Source</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 10:30:06</td>\n","      <td>2019-03-13 10:46:36</td>\n","      <td>990.0</td>\n","      <td>3987.500000</td>\n","      <td>1560.0</td>\n","      <td>7843.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230870</th>\n","      <th>7887842</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:47:00</td>\n","      <td>28.0</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>-0.4</td>\n","      <td>18.9</td>\n","      <td>6.8</td>\n","      <td>6.4</td>\n","      <td>0</td>\n","      <td>5.9</td>\n","      <td>2019-03-13 10:50:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Wandsbek Markt|Wandsbeker Allee</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 10:46:36</td>\n","      <td>2019-03-13 10:56:24</td>\n","      <td>588.0</td>\n","      <td>963.666667</td>\n","      <td>180.0</td>\n","      <td>945.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230871</th>\n","      <th>7887843</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:50:00</td>\n","      <td>28.0</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>6.4</td>\n","      <td>10.7</td>\n","      <td>11.4</td>\n","      <td>9.6</td>\n","      <td>0</td>\n","      <td>9.3</td>\n","      <td>2019-03-13 10:52:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Straßburger Straße</td>\n","      <td>Wandsbeker Allee|U Straßburger Straße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 10:56:24</td>\n","      <td>2019-03-13 10:58:36</td>\n","      <td>132.0</td>\n","      <td>341.000000</td>\n","      <td>120.0</td>\n","      <td>356.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230872</th>\n","      <th>7887844</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:52:00</td>\n","      <td>28.0</td>\n","      <td>U Straßburger Straße</td>\n","      <td>6.6</td>\n","      <td>15.7</td>\n","      <td>44.9</td>\n","      <td>39.3</td>\n","      <td>0</td>\n","      <td>26.2</td>\n","      <td>2019-03-13 10:54:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Alter Teichweg</td>\n","      <td>U Straßburger Straße|U Alter Teichweg</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 10:58:36</td>\n","      <td>2019-03-13 10:59:48</td>\n","      <td>72.0</td>\n","      <td>524.000000</td>\n","      <td>120.0</td>\n","      <td>523.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230873</th>\n","      <th>7887845</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:54:00</td>\n","      <td>28.0</td>\n","      <td>U Alter Teichweg</td>\n","      <td>5.8</td>\n","      <td>19.1</td>\n","      <td>7.1</td>\n","      <td>5.3</td>\n","      <td>0</td>\n","      <td>6.7</td>\n","      <td>2019-03-13 10:57:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Alter Teichweg|Habichtstraße (Mitte)</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 10:59:48</td>\n","      <td>2019-03-13 11:08:24</td>\n","      <td>516.0</td>\n","      <td>960.333333</td>\n","      <td>180.0</td>\n","      <td>955.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230874</th>\n","      <th>7887846</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:57:00</td>\n","      <td>28.0</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>11.4</td>\n","      <td>11.3</td>\n","      <td>23.5</td>\n","      <td>37.7</td>\n","      <td>0</td>\n","      <td>11.9</td>\n","      <td>2019-03-13 10:58:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Habichtstraße</td>\n","      <td>Habichtstraße (Mitte)|U Habichtstraße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:08:24</td>\n","      <td>2019-03-13 11:09:24</td>\n","      <td>60.0</td>\n","      <td>198.333333</td>\n","      <td>60.0</td>\n","      <td>188.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230875</th>\n","      <th>7887847</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 10:58:00</td>\n","      <td>28.0</td>\n","      <td>U Habichtstraße</td>\n","      <td>11.4</td>\n","      <td>12.4</td>\n","      <td>33.7</td>\n","      <td>29.2</td>\n","      <td>0</td>\n","      <td>25.6</td>\n","      <td>2019-03-13 11:00:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Habichtsplatz</td>\n","      <td>U Habichtstraße|Habichtsplatz</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:09:24</td>\n","      <td>2019-03-13 11:10:12</td>\n","      <td>48.0</td>\n","      <td>341.333333</td>\n","      <td>120.0</td>\n","      <td>413.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230876</th>\n","      <th>7887848</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:00:00</td>\n","      <td>28.0</td>\n","      <td>Habichtsplatz</td>\n","      <td>10.2</td>\n","      <td>13.9</td>\n","      <td>17.6</td>\n","      <td>15.3</td>\n","      <td>50</td>\n","      <td>15.6</td>\n","      <td>2019-03-13 11:02:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Neue Wöhr</td>\n","      <td>Habichtsplatz|Neue Wöhr</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:10:12</td>\n","      <td>2019-03-13 11:12:00</td>\n","      <td>108.0</td>\n","      <td>468.000000</td>\n","      <td>120.0</td>\n","      <td>463.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230877</th>\n","      <th>7887849</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:02:00</td>\n","      <td>28.0</td>\n","      <td>Neue Wöhr</td>\n","      <td>10.0</td>\n","      <td>19.0</td>\n","      <td>34.6</td>\n","      <td>29.0</td>\n","      <td>23</td>\n","      <td>21.9</td>\n","      <td>2019-03-13 11:03:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Hartzloh</td>\n","      <td>Neue Wöhr|Hartzloh</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:12:00</td>\n","      <td>2019-03-13 11:13:00</td>\n","      <td>60.0</td>\n","      <td>365.000000</td>\n","      <td>60.0</td>\n","      <td>316.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230878</th>\n","      <th>7887850</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:03:00</td>\n","      <td>28.0</td>\n","      <td>Hartzloh</td>\n","      <td>10.0</td>\n","      <td>19.8</td>\n","      <td>44.0</td>\n","      <td>33.3</td>\n","      <td>0</td>\n","      <td>21.6</td>\n","      <td>2019-03-13 11:04:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>AK Barmbek</td>\n","      <td>Hartzloh|AK Barmbek</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:13:00</td>\n","      <td>2019-03-13 11:13:54</td>\n","      <td>54.0</td>\n","      <td>324.000000</td>\n","      <td>60.0</td>\n","      <td>330.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230879</th>\n","      <th>7887851</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:04:00</td>\n","      <td>28.0</td>\n","      <td>AK Barmbek</td>\n","      <td>9.9</td>\n","      <td>13.0</td>\n","      <td>34.0</td>\n","      <td>28.1</td>\n","      <td>0</td>\n","      <td>22.3</td>\n","      <td>2019-03-13 11:06:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Hebebrandstraße</td>\n","      <td>AK Barmbek|Hebebrandstraße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:13:54</td>\n","      <td>2019-03-13 11:14:54</td>\n","      <td>60.0</td>\n","      <td>371.666667</td>\n","      <td>120.0</td>\n","      <td>433.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230880</th>\n","      <th>7887852</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:06:00</td>\n","      <td>28.0</td>\n","      <td>Hebebrandstraße</td>\n","      <td>8.9</td>\n","      <td>20.0</td>\n","      <td>29.3</td>\n","      <td>23.7</td>\n","      <td>29</td>\n","      <td>23.1</td>\n","      <td>2019-03-13 11:07:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>S Rübenkamp</td>\n","      <td>Hebebrandstraße|S Rübenkamp</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:14:54</td>\n","      <td>2019-03-13 11:15:36</td>\n","      <td>42.0</td>\n","      <td>269.500000</td>\n","      <td>60.0</td>\n","      <td>333.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230881</th>\n","      <th>7887854</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:08:00</td>\n","      <td>28.0</td>\n","      <td>S Rübenkamp</td>\n","      <td>8.7</td>\n","      <td>19.6</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>20</td>\n","      <td>-</td>\n","      <td>2019-03-13 11:25:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>S Rübenkamp</td>\n","      <td>Source</td>\n","      <td>S Rübenkamp|Source</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:16:42</td>\n","      <td>2019-03-13 11:24:12</td>\n","      <td>450.0</td>\n","      <td>NaN</td>\n","      <td>1020.0</td>\n","      <td>5553.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230882</th>\n","      <th>7887855</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:25:00</td>\n","      <td>28.0</td>\n","      <td>S Rübenkamp</td>\n","      <td>-0.8</td>\n","      <td>12.8</td>\n","      <td>26.4</td>\n","      <td>22.4</td>\n","      <td>17</td>\n","      <td>15.5</td>\n","      <td>2019-03-13 11:28:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>AK Barmbek</td>\n","      <td>S Rübenkamp|AK Barmbek</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:24:12</td>\n","      <td>2019-03-13 11:27:18</td>\n","      <td>186.0</td>\n","      <td>800.833333</td>\n","      <td>180.0</td>\n","      <td>640.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230883</th>\n","      <th>7887856</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:28:00</td>\n","      <td>28.0</td>\n","      <td>AK Barmbek</td>\n","      <td>-0.7</td>\n","      <td>24.5</td>\n","      <td>44.5</td>\n","      <td>38.4</td>\n","      <td>0</td>\n","      <td>23.0</td>\n","      <td>2019-03-13 11:29:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Hartzloh</td>\n","      <td>AK Barmbek|Hartzloh</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:27:18</td>\n","      <td>2019-03-13 11:28:36</td>\n","      <td>78.0</td>\n","      <td>498.333333</td>\n","      <td>60.0</td>\n","      <td>408.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230884</th>\n","      <th>7887857</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:29:00</td>\n","      <td>28.0</td>\n","      <td>Hartzloh</td>\n","      <td>-0.4</td>\n","      <td>16.7</td>\n","      <td>18.8</td>\n","      <td>17.5</td>\n","      <td>0</td>\n","      <td>15.4</td>\n","      <td>2019-03-13 11:32:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Habichtsplatz</td>\n","      <td>Hartzloh|Habichtsplatz</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:28:36</td>\n","      <td>2019-03-13 11:31:24</td>\n","      <td>168.0</td>\n","      <td>718.666667</td>\n","      <td>180.0</td>\n","      <td>835.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230885</th>\n","      <th>7887858</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:32:00</td>\n","      <td>28.0</td>\n","      <td>Habichtsplatz</td>\n","      <td>-0.6</td>\n","      <td>28.9</td>\n","      <td>19.2</td>\n","      <td>17.4</td>\n","      <td>39</td>\n","      <td>17.3</td>\n","      <td>2019-03-13 11:33:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Habichtstraße</td>\n","      <td>Habichtsplatz|U Habichtstraße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:31:24</td>\n","      <td>2019-03-13 11:33:06</td>\n","      <td>102.0</td>\n","      <td>490.166667</td>\n","      <td>60.0</td>\n","      <td>481.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230886</th>\n","      <th>7887859</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:33:00</td>\n","      <td>28.0</td>\n","      <td>U Habichtstraße</td>\n","      <td>0.1</td>\n","      <td>0.3</td>\n","      <td>0.9</td>\n","      <td>24.7</td>\n","      <td>15</td>\n","      <td>0.6</td>\n","      <td>2019-03-13 11:35:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Habichtstraße|Habichtstraße (Mitte)</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:33:06</td>\n","      <td>2019-03-13 11:34:12</td>\n","      <td>66.0</td>\n","      <td>11.000000</td>\n","      <td>120.0</td>\n","      <td>10.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230887</th>\n","      <th>7887860</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:35:00</td>\n","      <td>28.0</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>-0.8</td>\n","      <td>22.4</td>\n","      <td>7.1</td>\n","      <td>4.7</td>\n","      <td>0</td>\n","      <td>6.8</td>\n","      <td>2019-03-13 11:38:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Alter Teichweg</td>\n","      <td>Habichtstraße (Mitte)|U Alter Teichweg</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:34:12</td>\n","      <td>2019-03-13 11:44:12</td>\n","      <td>600.0</td>\n","      <td>1133.333333</td>\n","      <td>180.0</td>\n","      <td>1120.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230888</th>\n","      <th>7887861</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:38:00</td>\n","      <td>28.0</td>\n","      <td>U Alter Teichweg</td>\n","      <td>6.2</td>\n","      <td>17.3</td>\n","      <td>6.7</td>\n","      <td>5.9</td>\n","      <td>0</td>\n","      <td>6.3</td>\n","      <td>2019-03-13 11:40:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Straßburger Straße</td>\n","      <td>U Alter Teichweg|U Straßburger Straße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:44:12</td>\n","      <td>2019-03-13 11:49:30</td>\n","      <td>318.0</td>\n","      <td>556.500000</td>\n","      <td>120.0</td>\n","      <td>576.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230889</th>\n","      <th>7887862</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:40:00</td>\n","      <td>28.0</td>\n","      <td>U Straßburger Straße</td>\n","      <td>9.5</td>\n","      <td>17.2</td>\n","      <td>44.8</td>\n","      <td>29.7</td>\n","      <td>32</td>\n","      <td>22.4</td>\n","      <td>2019-03-13 11:41:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Straßburger Straße|Wandsbeker Allee</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:49:30</td>\n","      <td>2019-03-13 11:50:24</td>\n","      <td>54.0</td>\n","      <td>336.000000</td>\n","      <td>60.0</td>\n","      <td>286.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230890</th>\n","      <th>7887863</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 11:41:00</td>\n","      <td>28.0</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>9.4</td>\n","      <td>18.1</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>9.8</td>\n","      <td>2019-03-13 12:07:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Source</td>\n","      <td>Wandsbeker Allee|Source</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 11:50:24</td>\n","      <td>2019-03-13 12:07:36</td>\n","      <td>1032.0</td>\n","      <td>2809.333333</td>\n","      <td>1560.0</td>\n","      <td>7843.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230891</th>\n","      <th>7887864</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:07:00</td>\n","      <td>28.0</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>0.6</td>\n","      <td>18.9</td>\n","      <td>5.8</td>\n","      <td>5.5</td>\n","      <td>0</td>\n","      <td>5.7</td>\n","      <td>2019-03-13 12:10:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Wandsbek Markt|Wandsbeker Allee</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:07:36</td>\n","      <td>2019-03-13 12:17:36</td>\n","      <td>600.0</td>\n","      <td>950.000000</td>\n","      <td>180.0</td>\n","      <td>945.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230892</th>\n","      <th>7887865</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:10:00</td>\n","      <td>28.0</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>7.6</td>\n","      <td>10.7</td>\n","      <td>7.6</td>\n","      <td>6.7</td>\n","      <td>22</td>\n","      <td>6.7</td>\n","      <td>2019-03-13 12:12:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Straßburger Straße</td>\n","      <td>Wandsbeker Allee|U Straßburger Straße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:17:36</td>\n","      <td>2019-03-13 12:20:48</td>\n","      <td>192.0</td>\n","      <td>357.333333</td>\n","      <td>120.0</td>\n","      <td>356.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230893</th>\n","      <th>7887866</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:12:00</td>\n","      <td>28.0</td>\n","      <td>U Straßburger Straße</td>\n","      <td>8.8</td>\n","      <td>15.7</td>\n","      <td>30.4</td>\n","      <td>27.6</td>\n","      <td>0</td>\n","      <td>19.4</td>\n","      <td>2019-03-13 12:14:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Alter Teichweg</td>\n","      <td>U Straßburger Straße|U Alter Teichweg</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:20:48</td>\n","      <td>2019-03-13 12:22:30</td>\n","      <td>102.0</td>\n","      <td>549.666667</td>\n","      <td>120.0</td>\n","      <td>523.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230894</th>\n","      <th>7887867</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:14:00</td>\n","      <td>28.0</td>\n","      <td>U Alter Teichweg</td>\n","      <td>8.5</td>\n","      <td>19.1</td>\n","      <td>15.0</td>\n","      <td>11.3</td>\n","      <td>0</td>\n","      <td>11.6</td>\n","      <td>2019-03-13 12:17:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Alter Teichweg|Habichtstraße (Mitte)</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:22:30</td>\n","      <td>2019-03-13 12:27:24</td>\n","      <td>294.0</td>\n","      <td>947.333333</td>\n","      <td>180.0</td>\n","      <td>955.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230895</th>\n","      <th>7887868</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:17:00</td>\n","      <td>28.0</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>10.4</td>\n","      <td>11.3</td>\n","      <td>10.6</td>\n","      <td>17.3</td>\n","      <td>0</td>\n","      <td>7.1</td>\n","      <td>2019-03-13 12:18:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>U Habichtstraße</td>\n","      <td>Habichtstraße (Mitte)|U Habichtstraße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:27:24</td>\n","      <td>2019-03-13 12:29:00</td>\n","      <td>96.0</td>\n","      <td>189.333333</td>\n","      <td>60.0</td>\n","      <td>188.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230896</th>\n","      <th>7887869</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:18:00</td>\n","      <td>28.0</td>\n","      <td>U Habichtstraße</td>\n","      <td>11.0</td>\n","      <td>12.4</td>\n","      <td>22.8</td>\n","      <td>20.2</td>\n","      <td>0</td>\n","      <td>16.1</td>\n","      <td>2019-03-13 12:20:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Habichtsplatz</td>\n","      <td>U Habichtstraße|Habichtsplatz</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:29:00</td>\n","      <td>2019-03-13 12:30:30</td>\n","      <td>90.0</td>\n","      <td>402.500000</td>\n","      <td>120.0</td>\n","      <td>413.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230897</th>\n","      <th>7887870</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:20:00</td>\n","      <td>28.0</td>\n","      <td>Habichtsplatz</td>\n","      <td>10.5</td>\n","      <td>13.9</td>\n","      <td>22.3</td>\n","      <td>19.4</td>\n","      <td>0</td>\n","      <td>15.0</td>\n","      <td>2019-03-13 12:22:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Neue Wöhr</td>\n","      <td>Habichtsplatz|Neue Wöhr</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:30:30</td>\n","      <td>2019-03-13 12:32:18</td>\n","      <td>108.0</td>\n","      <td>450.000000</td>\n","      <td>120.0</td>\n","      <td>463.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230898</th>\n","      <th>7887871</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:22:00</td>\n","      <td>28.0</td>\n","      <td>Neue Wöhr</td>\n","      <td>10.3</td>\n","      <td>19.0</td>\n","      <td>40.8</td>\n","      <td>34.2</td>\n","      <td>10</td>\n","      <td>21.9</td>\n","      <td>2019-03-13 12:23:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Hartzloh</td>\n","      <td>Neue Wöhr|Hartzloh</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:32:18</td>\n","      <td>2019-03-13 12:33:18</td>\n","      <td>60.0</td>\n","      <td>365.000000</td>\n","      <td>60.0</td>\n","      <td>316.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230899</th>\n","      <th>7887872</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:23:00</td>\n","      <td>28.0</td>\n","      <td>Hartzloh</td>\n","      <td>10.3</td>\n","      <td>19.8</td>\n","      <td>44.0</td>\n","      <td>36.5</td>\n","      <td>0</td>\n","      <td>20.8</td>\n","      <td>2019-03-13 12:24:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>AK Barmbek</td>\n","      <td>Hartzloh|AK Barmbek</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:33:18</td>\n","      <td>2019-03-13 12:34:24</td>\n","      <td>66.0</td>\n","      <td>381.333333</td>\n","      <td>60.0</td>\n","      <td>330.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230900</th>\n","      <th>7887873</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:24:00</td>\n","      <td>28.0</td>\n","      <td>AK Barmbek</td>\n","      <td>10.4</td>\n","      <td>13.0</td>\n","      <td>15.0</td>\n","      <td>13.3</td>\n","      <td>0</td>\n","      <td>10.9</td>\n","      <td>2019-03-13 12:26:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>Hebebrandstraße</td>\n","      <td>AK Barmbek|Hebebrandstraße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:34:24</td>\n","      <td>2019-03-13 12:36:42</td>\n","      <td>138.0</td>\n","      <td>417.833333</td>\n","      <td>120.0</td>\n","      <td>433.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230901</th>\n","      <th>7887874</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:26:00</td>\n","      <td>28.0</td>\n","      <td>Hebebrandstraße</td>\n","      <td>10.7</td>\n","      <td>20.0</td>\n","      <td>46.2</td>\n","      <td>37.0</td>\n","      <td>0</td>\n","      <td>26.1</td>\n","      <td>2019-03-13 12:27:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>S Rübenkamp</td>\n","      <td>S Rübenkamp</td>\n","      <td>Hebebrandstraße|S Rübenkamp</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:36:42</td>\n","      <td>2019-03-13 12:37:06</td>\n","      <td>24.0</td>\n","      <td>174.000000</td>\n","      <td>60.0</td>\n","      <td>333.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230902</th>\n","      <th>7887876</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:28:00</td>\n","      <td>28.0</td>\n","      <td>S Rübenkamp</td>\n","      <td>11.3</td>\n","      <td>19.6</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>20</td>\n","      <td>-</td>\n","      <td>2019-03-13 12:45:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>S Rübenkamp</td>\n","      <td>Source</td>\n","      <td>S Rübenkamp|Source</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:39:18</td>\n","      <td>2019-03-13 12:44:12</td>\n","      <td>294.0</td>\n","      <td>NaN</td>\n","      <td>1020.0</td>\n","      <td>5553.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230903</th>\n","      <th>7887877</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:45:00</td>\n","      <td>28.0</td>\n","      <td>S Rübenkamp</td>\n","      <td>-0.8</td>\n","      <td>12.8</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>14</td>\n","      <td>12.9</td>\n","      <td>2019-03-13 12:48:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>AK Barmbek</td>\n","      <td>S Rübenkamp|AK Barmbek</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:44:12</td>\n","      <td>2019-03-13 12:47:06</td>\n","      <td>174.0</td>\n","      <td>623.500000</td>\n","      <td>180.0</td>\n","      <td>640.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230904</th>\n","      <th>7887878</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:48:00</td>\n","      <td>28.0</td>\n","      <td>AK Barmbek</td>\n","      <td>-0.9</td>\n","      <td>24.5</td>\n","      <td>43.2</td>\n","      <td>37.2</td>\n","      <td>0</td>\n","      <td>14.4</td>\n","      <td>2019-03-13 12:49:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Hartzloh</td>\n","      <td>AK Barmbek|Hartzloh</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:47:06</td>\n","      <td>2019-03-13 12:48:42</td>\n","      <td>96.0</td>\n","      <td>384.000000</td>\n","      <td>60.0</td>\n","      <td>408.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230905</th>\n","      <th>7887879</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:49:00</td>\n","      <td>28.0</td>\n","      <td>Hartzloh</td>\n","      <td>-0.3</td>\n","      <td>16.7</td>\n","      <td>38.6</td>\n","      <td>35.5</td>\n","      <td>0</td>\n","      <td>20.2</td>\n","      <td>2019-03-13 12:52:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Habichtsplatz</td>\n","      <td>Hartzloh|Habichtsplatz</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:48:42</td>\n","      <td>2019-03-13 12:51:06</td>\n","      <td>144.0</td>\n","      <td>808.000000</td>\n","      <td>180.0</td>\n","      <td>835.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230906</th>\n","      <th>7887880</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:52:00</td>\n","      <td>28.0</td>\n","      <td>Habichtsplatz</td>\n","      <td>-0.9</td>\n","      <td>28.9</td>\n","      <td>17.3</td>\n","      <td>15.7</td>\n","      <td>18</td>\n","      <td>15.1</td>\n","      <td>2019-03-13 12:53:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Habichtstraße</td>\n","      <td>Habichtsplatz|U Habichtstraße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:51:06</td>\n","      <td>2019-03-13 12:53:06</td>\n","      <td>120.0</td>\n","      <td>503.333333</td>\n","      <td>60.0</td>\n","      <td>481.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230907</th>\n","      <th>7887881</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:53:00</td>\n","      <td>28.0</td>\n","      <td>U Habichtstraße</td>\n","      <td>0.1</td>\n","      <td>0.3</td>\n","      <td>0.5</td>\n","      <td>12.7</td>\n","      <td>0</td>\n","      <td>0.3</td>\n","      <td>2019-03-13 12:55:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Habichtstraße|Habichtstraße (Mitte)</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:53:06</td>\n","      <td>2019-03-13 12:54:48</td>\n","      <td>102.0</td>\n","      <td>8.500000</td>\n","      <td>120.0</td>\n","      <td>10.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230908</th>\n","      <th>7887882</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:55:00</td>\n","      <td>28.0</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>-0.2</td>\n","      <td>22.4</td>\n","      <td>7.6</td>\n","      <td>5.0</td>\n","      <td>0</td>\n","      <td>7.1</td>\n","      <td>2019-03-13 12:58:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Alter Teichweg</td>\n","      <td>Habichtstraße (Mitte)|U Alter Teichweg</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 12:54:48</td>\n","      <td>2019-03-13 13:04:12</td>\n","      <td>564.0</td>\n","      <td>1112.333333</td>\n","      <td>180.0</td>\n","      <td>1120.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230909</th>\n","      <th>7887883</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 12:58:00</td>\n","      <td>28.0</td>\n","      <td>U Alter Teichweg</td>\n","      <td>6.2</td>\n","      <td>17.3</td>\n","      <td>5.9</td>\n","      <td>5.4</td>\n","      <td>8</td>\n","      <td>5.7</td>\n","      <td>2019-03-13 13:00:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Straßburger Straße</td>\n","      <td>U Alter Teichweg|U Straßburger Straße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 13:04:12</td>\n","      <td>2019-03-13 13:10:18</td>\n","      <td>366.0</td>\n","      <td>579.500000</td>\n","      <td>120.0</td>\n","      <td>576.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230910</th>\n","      <th>7887884</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 13:00:00</td>\n","      <td>28.0</td>\n","      <td>U Straßburger Straße</td>\n","      <td>10.3</td>\n","      <td>17.2</td>\n","      <td>27.1</td>\n","      <td>21.1</td>\n","      <td>60</td>\n","      <td>23.4</td>\n","      <td>2019-03-13 13:01:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Straßburger Straße|Wandsbeker Allee</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 13:10:18</td>\n","      <td>2019-03-13 13:11:00</td>\n","      <td>42.0</td>\n","      <td>273.000000</td>\n","      <td>60.0</td>\n","      <td>286.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230911</th>\n","      <th>7887885</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 13:01:00</td>\n","      <td>28.0</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>10.0</td>\n","      <td>18.1</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>36</td>\n","      <td>12.9</td>\n","      <td>2019-03-13 13:27:00</td>\n","      <td>S Rübenkamp</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Source</td>\n","      <td>Wandsbeker Allee|Source</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 13:11:00</td>\n","      <td>2019-03-13 13:26:30</td>\n","      <td>930.0</td>\n","      <td>3332.500000</td>\n","      <td>1560.0</td>\n","      <td>7843.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230912</th>\n","      <th>7887886</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 13:27:00</td>\n","      <td>28.0</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>-0.5</td>\n","      <td>18.9</td>\n","      <td>2.8</td>\n","      <td>2.6</td>\n","      <td>12</td>\n","      <td>2.8</td>\n","      <td>2019-03-13 13:30:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>U Wandsbek Markt|Wandsbeker Allee</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 13:26:30</td>\n","      <td>2019-03-13 13:46:48</td>\n","      <td>1218.0</td>\n","      <td>947.333333</td>\n","      <td>180.0</td>\n","      <td>945.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230913</th>\n","      <th>7887887</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 13:30:00</td>\n","      <td>28.0</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>16.8</td>\n","      <td>10.7</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>36</td>\n","      <td>-</td>\n","      <td>2019-03-13 14:08:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>Wandsbeker Allee</td>\n","      <td>Source</td>\n","      <td>Wandsbeker Allee|Source</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 13:46:48</td>\n","      <td>2019-03-13 14:07:30</td>\n","      <td>1242.0</td>\n","      <td>NaN</td>\n","      <td>2280.0</td>\n","      <td>6776.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230914</th>\n","      <th>7887888</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 14:08:00</td>\n","      <td>28.0</td>\n","      <td>AK Barmbek</td>\n","      <td>-0.5</td>\n","      <td>24.5</td>\n","      <td>42.0</td>\n","      <td>35.9</td>\n","      <td>0</td>\n","      <td>19.3</td>\n","      <td>2019-03-13 14:09:00</td>\n","      <td>AK Barmbek</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>Hartzloh</td>\n","      <td>AK Barmbek|Hartzloh</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 14:07:30</td>\n","      <td>2019-03-13 14:08:48</td>\n","      <td>78.0</td>\n","      <td>418.166667</td>\n","      <td>60.0</td>\n","      <td>408.333333</td>\n","    </tr>\n","    <tr>\n","      <th>230915</th>\n","      <th>7887889</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 14:09:00</td>\n","      <td>28.0</td>\n","      <td>Hartzloh</td>\n","      <td>-0.2</td>\n","      <td>16.7</td>\n","      <td>16.3</td>\n","      <td>15.1</td>\n","      <td>0</td>\n","      <td>14.0</td>\n","      <td>2019-03-13 14:12:00</td>\n","      <td>AK Barmbek</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>Habichtsplatz</td>\n","      <td>Hartzloh|Habichtsplatz</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 14:08:48</td>\n","      <td>2019-03-13 14:12:18</td>\n","      <td>210.0</td>\n","      <td>816.666667</td>\n","      <td>180.0</td>\n","      <td>835.000000</td>\n","    </tr>\n","    <tr>\n","      <th>230916</th>\n","      <th>7887890</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 14:12:00</td>\n","      <td>28.0</td>\n","      <td>Habichtsplatz</td>\n","      <td>0.3</td>\n","      <td>28.9</td>\n","      <td>11.9</td>\n","      <td>10.5</td>\n","      <td>0</td>\n","      <td>9.5</td>\n","      <td>2019-03-13 14:13:00</td>\n","      <td>AK Barmbek</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Habichtstraße</td>\n","      <td>Habichtsplatz|U Habichtstraße</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 14:12:18</td>\n","      <td>2019-03-13 14:16:00</td>\n","      <td>222.0</td>\n","      <td>585.833333</td>\n","      <td>60.0</td>\n","      <td>481.666667</td>\n","    </tr>\n","    <tr>\n","      <th>230917</th>\n","      <th>7887891</th>\n","      <td>13.03.2019</td>\n","      <td>88094.0</td>\n","      <td>1504.0</td>\n","      <td>2019-03-13 14:13:00</td>\n","      <td>28.0</td>\n","      <td>U Habichtstraße</td>\n","      <td>3.0</td>\n","      <td>0.3</td>\n","      <td>0.3</td>\n","      <td>6.4</td>\n","      <td>0</td>\n","      <td>0.2</td>\n","      <td>2019-03-13 14:15:00</td>\n","      <td>AK Barmbek</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>Habichtstraße (Mitte)</td>\n","      <td>U Habichtstraße|Habichtstraße (Mitte)</td>\n","      <td>13.03.2019</td>\n","      <td>2019-03-13 14:16:00</td>\n","      <td>2019-03-13 14:18:54</td>\n","      <td>174.0</td>\n","      <td>9.666667</td>\n","      <td>120.0</td>\n","      <td>10.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                     Datum      UML  ...  Driving_time_s_p Distance_m_p\n","230868 7887840  13.03.2019  88094.0  ...              60.0   286.666667\n","230869 7887841  13.03.2019  88094.0  ...            1560.0  7843.333333\n","230870 7887842  13.03.2019  88094.0  ...             180.0   945.000000\n","230871 7887843  13.03.2019  88094.0  ...             120.0   356.666667\n","230872 7887844  13.03.2019  88094.0  ...             120.0   523.333333\n","230873 7887845  13.03.2019  88094.0  ...             180.0   955.000000\n","230874 7887846  13.03.2019  88094.0  ...              60.0   188.333333\n","230875 7887847  13.03.2019  88094.0  ...             120.0   413.333333\n","230876 7887848  13.03.2019  88094.0  ...             120.0   463.333333\n","230877 7887849  13.03.2019  88094.0  ...              60.0   316.666667\n","230878 7887850  13.03.2019  88094.0  ...              60.0   330.000000\n","230879 7887851  13.03.2019  88094.0  ...             120.0   433.333333\n","230880 7887852  13.03.2019  88094.0  ...              60.0   333.333333\n","230881 7887854  13.03.2019  88094.0  ...            1020.0  5553.333333\n","230882 7887855  13.03.2019  88094.0  ...             180.0   640.000000\n","230883 7887856  13.03.2019  88094.0  ...              60.0   408.333333\n","230884 7887857  13.03.2019  88094.0  ...             180.0   835.000000\n","230885 7887858  13.03.2019  88094.0  ...              60.0   481.666667\n","230886 7887859  13.03.2019  88094.0  ...             120.0    10.000000\n","230887 7887860  13.03.2019  88094.0  ...             180.0  1120.000000\n","230888 7887861  13.03.2019  88094.0  ...             120.0   576.666667\n","230889 7887862  13.03.2019  88094.0  ...              60.0   286.666667\n","230890 7887863  13.03.2019  88094.0  ...            1560.0  7843.333333\n","230891 7887864  13.03.2019  88094.0  ...             180.0   945.000000\n","230892 7887865  13.03.2019  88094.0  ...             120.0   356.666667\n","230893 7887866  13.03.2019  88094.0  ...             120.0   523.333333\n","230894 7887867  13.03.2019  88094.0  ...             180.0   955.000000\n","230895 7887868  13.03.2019  88094.0  ...              60.0   188.333333\n","230896 7887869  13.03.2019  88094.0  ...             120.0   413.333333\n","230897 7887870  13.03.2019  88094.0  ...             120.0   463.333333\n","230898 7887871  13.03.2019  88094.0  ...              60.0   316.666667\n","230899 7887872  13.03.2019  88094.0  ...              60.0   330.000000\n","230900 7887873  13.03.2019  88094.0  ...             120.0   433.333333\n","230901 7887874  13.03.2019  88094.0  ...              60.0   333.333333\n","230902 7887876  13.03.2019  88094.0  ...            1020.0  5553.333333\n","230903 7887877  13.03.2019  88094.0  ...             180.0   640.000000\n","230904 7887878  13.03.2019  88094.0  ...              60.0   408.333333\n","230905 7887879  13.03.2019  88094.0  ...             180.0   835.000000\n","230906 7887880  13.03.2019  88094.0  ...              60.0   481.666667\n","230907 7887881  13.03.2019  88094.0  ...             120.0    10.000000\n","230908 7887882  13.03.2019  88094.0  ...             180.0  1120.000000\n","230909 7887883  13.03.2019  88094.0  ...             120.0   576.666667\n","230910 7887884  13.03.2019  88094.0  ...              60.0   286.666667\n","230911 7887885  13.03.2019  88094.0  ...            1560.0  7843.333333\n","230912 7887886  13.03.2019  88094.0  ...             180.0   945.000000\n","230913 7887887  13.03.2019  88094.0  ...            2280.0  6776.666667\n","230914 7887888  13.03.2019  88094.0  ...              60.0   408.333333\n","230915 7887889  13.03.2019  88094.0  ...             180.0   835.000000\n","230916 7887890  13.03.2019  88094.0  ...              60.0   481.666667\n","230917 7887891  13.03.2019  88094.0  ...             120.0    10.000000\n","\n","[50 rows x 24 columns]"]},"metadata":{"tags":[]},"execution_count":8}]},{"cell_type":"code","metadata":{"id":"AJ-VoEkUX3Cr"},"source":["data_ist_fil['Ab_ZT_PLAN'] = data_ist_fil['Ab_ZT_PLAN'].astype('datetime64[ns]')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"i4TBb78JZA-K","executionInfo":{"status":"ok","timestamp":1602805083544,"user_tz":-120,"elapsed":5519,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"91259a18-7bad-4423-e046-1cd927c7d6ae","colab":{"base_uri":"https://localhost:8080/","height":442}},"source":["data_ist_fil.dtypes"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Datum                           object\n","UML                            float64\n","Wagen                          float64\n","Ab_ZT_PLAN              datetime64[ns]\n","Linie                           object\n","Haltestelle                     object\n","Fahrplanlage_IST               float64\n","v_PLAN                         float64\n","v_IST_S2S1                      object\n","v_netto_S2S1                    object\n","FFVP_GESCHWINDIGKEIT            object\n","v_IST                           object\n","Ank_ZT_PLAN                     object\n","S_Station                       object\n","E_Station                       object\n","NHaltestelle                    object\n","Node A to Node B                object\n","date                            object\n","Ab_ZT_ACTUAL                    object\n","Ank_ZT_ACTUAL                   object\n","Driving_time_s                 float64\n","Distance_m                     float64\n","Driving_time_s_p               float64\n","Distance_m_p                   float64\n","dtype: object"]},"metadata":{"tags":[]},"execution_count":7}]},{"cell_type":"code","metadata":{"id":"-XHx9xXMZN3U","executionInfo":{"status":"ok","timestamp":1602801316948,"user_tz":-120,"elapsed":6544,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"2bfebc8a-08ad-4460-a2ed-c0973ec3e7b0","colab":{"base_uri":"https://localhost:8080/","height":609}},"source":["data_ist_fil.loc[data_ist_fil['Ab_ZT_PLAN'].dt.month <7]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Datum</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Ab_ZT_PLAN</th>\n","      <th>Linie</th>\n","      <th>Haltestelle</th>\n","      <th>Fahrplanlage_IST</th>\n","      <th>v_PLAN</th>\n","      <th>v_IST_S2S1</th>\n","      <th>v_netto_S2S1</th>\n","      <th>FFVP_GESCHWINDIGKEIT</th>\n","      <th>v_IST</th>\n","      <th>Ank_ZT_PLAN</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>NHaltestelle</th>\n","      <th>Node A to Node B</th>\n","      <th>date</th>\n","      <th>Ab_ZT_ACTUAL</th>\n","      <th>Ank_ZT_ACTUAL</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:08:00</td>\n","      <td>171</td>\n","      <td>Eckerkoppel</td>\n","      <td>0.1</td>\n","      <td>36.1</td>\n","      <td>49.2</td>\n","      <td>45.2</td>\n","      <td>35</td>\n","      <td>44.2</td>\n","      <td>2019-05-01 04:09:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Ebeersreye</td>\n","      <td>Eckerkoppel|Ebeersreye</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:08:06</td>\n","      <td>2019-05-01 04:08:54</td>\n","      <td>48.0</td>\n","      <td>589.333333</td>\n","      <td>60.0</td>\n","      <td>601.666667</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:09:00</td>\n","      <td>171</td>\n","      <td>Ebeersreye</td>\n","      <td>-0.1</td>\n","      <td>20.1</td>\n","      <td>14.3</td>\n","      <td>13.2</td>\n","      <td>38</td>\n","      <td>13.9</td>\n","      <td>2019-05-01 04:11:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>Ebeersreye|Rentenversicherung Nord</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:08:54</td>\n","      <td>2019-05-01 04:11:48</td>\n","      <td>174.0</td>\n","      <td>671.833333</td>\n","      <td>120.0</td>\n","      <td>670.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:11:00</td>\n","      <td>171</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>0.8</td>\n","      <td>19.1</td>\n","      <td>47.9</td>\n","      <td>41.4</td>\n","      <td>45</td>\n","      <td>30.2</td>\n","      <td>2019-05-01 04:12:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Sylter Weg</td>\n","      <td>Rentenversicherung Nord|Sylter Weg</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:11:48</td>\n","      <td>2019-05-01 04:12:30</td>\n","      <td>42.0</td>\n","      <td>352.333333</td>\n","      <td>60.0</td>\n","      <td>318.333333</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:12:00</td>\n","      <td>171</td>\n","      <td>Sylter Weg</td>\n","      <td>0.5</td>\n","      <td>28.4</td>\n","      <td>18.5</td>\n","      <td>16.2</td>\n","      <td>0</td>\n","      <td>16.3</td>\n","      <td>2019-05-01 04:13:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Am Stadtrand</td>\n","      <td>Sylter Weg|Am Stadtrand</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:12:30</td>\n","      <td>2019-05-01 04:14:06</td>\n","      <td>96.0</td>\n","      <td>434.666667</td>\n","      <td>60.0</td>\n","      <td>473.333333</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>01.05.2019</td>\n","      <td>88001.0</td>\n","      <td>1506.0</td>\n","      <td>2019-05-01 04:13:00</td>\n","      <td>171</td>\n","      <td>Am Stadtrand</td>\n","      <td>1.1</td>\n","      <td>21.2</td>\n","      <td>50.8</td>\n","      <td>44.5</td>\n","      <td>43</td>\n","      <td>43.8</td>\n","      <td>2019-05-01 04:14:00</td>\n","      <td>U Farmsen</td>\n","      <td>Straßburger Platz</td>\n","      <td>Helbingtwiete</td>\n","      <td>Am Stadtrand|Helbingtwiete</td>\n","      <td>01.05.2019</td>\n","      <td>2019-05-01 04:14:06</td>\n","      <td>2019-05-01 04:14:36</td>\n","      <td>30.0</td>\n","      <td>365.000000</td>\n","      <td>60.0</td>\n","      <td>353.333333</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>18903030</th>\n","      <td>25.02.2019</td>\n","      <td>88089.0</td>\n","      <td>1632.0</td>\n","      <td>2019-02-25 09:54:00</td>\n","      <td>8</td>\n","      <td>Pfeilshofer Weg</td>\n","      <td>1.1</td>\n","      <td>10.8</td>\n","      <td>18.2</td>\n","      <td>15.4</td>\n","      <td>0</td>\n","      <td>12.8</td>\n","      <td>2019-02-25 09:56:00</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>Rolfinckstraße</td>\n","      <td>Pfeilshofer Weg|Rolfinckstraße</td>\n","      <td>25.02.2019</td>\n","      <td>2019-02-25 09:55:06</td>\n","      <td>2019-02-25 09:56:48</td>\n","      <td>102.0</td>\n","      <td>362.666667</td>\n","      <td>120.0</td>\n","      <td>360.000000</td>\n","    </tr>\n","    <tr>\n","      <th>18903031</th>\n","      <td>25.02.2019</td>\n","      <td>88089.0</td>\n","      <td>1632.0</td>\n","      <td>2019-02-25 09:56:00</td>\n","      <td>8</td>\n","      <td>Rolfinckstraße</td>\n","      <td>0.8</td>\n","      <td>27.0</td>\n","      <td>33.4</td>\n","      <td>31.0</td>\n","      <td>0</td>\n","      <td>19.2</td>\n","      <td>2019-02-25 09:58:00</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>Am Damm</td>\n","      <td>Rolfinckstraße|Am Damm</td>\n","      <td>25.02.2019</td>\n","      <td>2019-02-25 09:56:48</td>\n","      <td>2019-02-25 09:59:36</td>\n","      <td>168.0</td>\n","      <td>896.000000</td>\n","      <td>120.0</td>\n","      <td>900.000000</td>\n","    </tr>\n","    <tr>\n","      <th>18903032</th>\n","      <td>25.02.2019</td>\n","      <td>88089.0</td>\n","      <td>1632.0</td>\n","      <td>2019-02-25 09:58:00</td>\n","      <td>8</td>\n","      <td>Am Damm</td>\n","      <td>1.6</td>\n","      <td>33.5</td>\n","      <td>47.8</td>\n","      <td>42.8</td>\n","      <td>0</td>\n","      <td>34.0</td>\n","      <td>2019-02-25 09:59:00</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>Maisredder</td>\n","      <td>Am Damm|Maisredder</td>\n","      <td>25.02.2019</td>\n","      <td>2019-02-25 09:59:36</td>\n","      <td>2019-02-25 10:00:24</td>\n","      <td>48.0</td>\n","      <td>453.333333</td>\n","      <td>60.0</td>\n","      <td>558.333333</td>\n","    </tr>\n","    <tr>\n","      <th>18903033</th>\n","      <td>25.02.2019</td>\n","      <td>88089.0</td>\n","      <td>1632.0</td>\n","      <td>2019-02-25 09:59:00</td>\n","      <td>8</td>\n","      <td>Maisredder</td>\n","      <td>1.4</td>\n","      <td>26.2</td>\n","      <td>50.6</td>\n","      <td>45.4</td>\n","      <td>43</td>\n","      <td>27.1</td>\n","      <td>2019-02-25 10:00:00</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>Königsberger Straße</td>\n","      <td>Maisredder|Königsberger Straße</td>\n","      <td>25.02.2019</td>\n","      <td>2019-02-25 10:00:24</td>\n","      <td>2019-02-25 10:01:36</td>\n","      <td>72.0</td>\n","      <td>542.000000</td>\n","      <td>60.0</td>\n","      <td>436.666667</td>\n","    </tr>\n","    <tr>\n","      <th>18903034</th>\n","      <td>25.02.2019</td>\n","      <td>88089.0</td>\n","      <td>1632.0</td>\n","      <td>2019-02-25 10:00:00</td>\n","      <td>8</td>\n","      <td>Königsberger Straße</td>\n","      <td>1.6</td>\n","      <td>17.2</td>\n","      <td>31.8</td>\n","      <td>28.7</td>\n","      <td>0</td>\n","      <td>19.9</td>\n","      <td>2019-02-25 10:02:00</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>S Poppenbüttel (Stormarnplatz)</td>\n","      <td>Berner Chaussee</td>\n","      <td>Königsberger Straße|Berner Chaussee</td>\n","      <td>25.02.2019</td>\n","      <td>2019-02-25 10:01:36</td>\n","      <td>2019-02-25 10:03:18</td>\n","      <td>102.0</td>\n","      <td>563.833333</td>\n","      <td>120.0</td>\n","      <td>573.333333</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>8914859 rows × 24 columns</p>\n","</div>"],"text/plain":["               Datum      UML  ...  Driving_time_s_p Distance_m_p\n","2         01.05.2019  88001.0  ...              60.0   601.666667\n","3         01.05.2019  88001.0  ...             120.0   670.000000\n","4         01.05.2019  88001.0  ...              60.0   318.333333\n","5         01.05.2019  88001.0  ...              60.0   473.333333\n","6         01.05.2019  88001.0  ...              60.0   353.333333\n","...              ...      ...  ...               ...          ...\n","18903030  25.02.2019  88089.0  ...             120.0   360.000000\n","18903031  25.02.2019  88089.0  ...             120.0   900.000000\n","18903032  25.02.2019  88089.0  ...              60.0   558.333333\n","18903033  25.02.2019  88089.0  ...              60.0   436.666667\n","18903034  25.02.2019  88089.0  ...             120.0   573.333333\n","\n","[8914859 rows x 24 columns]"]},"metadata":{"tags":[]},"execution_count":14}]},{"cell_type":"code","metadata":{"id":"-4MA1QVHt3L6","executionInfo":{"status":"ok","timestamp":1602805090455,"user_tz":-120,"elapsed":3330,"user":{"displayName":"Thummaporn Nimpanomprasert","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GibcIKJrqz9NtUSf2dJxz4qJOkqpMFT1NfSmu9HQQ=s64","userId":"01376364400975693249"}},"outputId":"81c3a082-7e0f-4195-d7e0-eba2d50215f1","colab":{"base_uri":"https://localhost:8080/","height":694}},"source":["#filter ONLY first 6 month\n","data_ist_fil_01_06 = data_ist_fil.loc[data_ist_fil['Ab_ZT_PLAN'].dt.month <2].reset_index(drop = True)\n","data_ist_fil_01_06"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Datum</th>\n","      <th>UML</th>\n","      <th>Wagen</th>\n","      <th>Ab_ZT_PLAN</th>\n","      <th>Linie</th>\n","      <th>Haltestelle</th>\n","      <th>Fahrplanlage_IST</th>\n","      <th>v_PLAN</th>\n","      <th>v_IST_S2S1</th>\n","      <th>v_netto_S2S1</th>\n","      <th>FFVP_GESCHWINDIGKEIT</th>\n","      <th>v_IST</th>\n","      <th>Ank_ZT_PLAN</th>\n","      <th>S_Station</th>\n","      <th>E_Station</th>\n","      <th>NHaltestelle</th>\n","      <th>Node A to Node B</th>\n","      <th>date</th>\n","      <th>Ab_ZT_ACTUAL</th>\n","      <th>Ank_ZT_ACTUAL</th>\n","      <th>Driving_time_s</th>\n","      <th>Distance_m</th>\n","      <th>Driving_time_s_p</th>\n","      <th>Distance_m_p</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>01.01.2019</td>\n","      <td>88001.0</td>\n","      <td>1213.0</td>\n","      <td>2019-01-01 04:46:00</td>\n","      <td>171.0</td>\n","      <td>U Farmsen</td>\n","      <td>0.5</td>\n","      <td>19.0</td>\n","      <td>9.2</td>\n","      <td>7.8</td>\n","      <td>14</td>\n","      <td>8.4</td>\n","      <td>2019-01-01 04:47:00</td>\n","      <td>U Farmsen</td>\n","      <td>U S Barmbek</td>\n","      <td>Eissporthalle</td>\n","      <td>U Farmsen|Eissporthalle</td>\n","      <td>01.01.2019</td>\n","      <td>2019-01-01 04:46:30</td>\n","      <td>2019-01-01 04:48:48</td>\n","      <td>138.0</td>\n","      <td>322.000000</td>\n","      <td>60.0</td>\n","      <td>316.666667</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>01.01.2019</td>\n","      <td>88001.0</td>\n","      <td>1213.0</td>\n","      <td>2019-01-01 04:47:00</td>\n","      <td>171.0</td>\n","      <td>Eissporthalle</td>\n","      <td>1.8</td>\n","      <td>25.3</td>\n","      <td>39.9</td>\n","      <td>35.8</td>\n","      <td>18</td>\n","      <td>17.6</td>\n","      <td>2019-01-01 04:48:00</td>\n","      <td>U Farmsen</td>\n","      <td>U S Barmbek</td>\n","      <td>Eckerkoppel</td>\n","      <td>Eissporthalle|Eckerkoppel</td>\n","      <td>01.01.2019</td>\n","      <td>2019-01-01 04:48:48</td>\n","      <td>2019-01-01 04:50:18</td>\n","      <td>90.0</td>\n","      <td>440.000000</td>\n","      <td>60.0</td>\n","      <td>421.666667</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>01.01.2019</td>\n","      <td>88001.0</td>\n","      <td>1213.0</td>\n","      <td>2019-01-01 04:48:00</td>\n","      <td>171.0</td>\n","      <td>Eckerkoppel</td>\n","      <td>2.3</td>\n","      <td>36.1</td>\n","      <td>38.0</td>\n","      <td>34.6</td>\n","      <td>0</td>\n","      <td>24.0</td>\n","      <td>2019-01-01 04:49:00</td>\n","      <td>U Farmsen</td>\n","      <td>U S Barmbek</td>\n","      <td>Ebeersreye</td>\n","      <td>Eckerkoppel|Ebeersreye</td>\n","      <td>01.01.2019</td>\n","      <td>2019-01-01 04:50:18</td>\n","      <td>2019-01-01 04:51:48</td>\n","      <td>90.0</td>\n","      <td>600.000000</td>\n","      <td>60.0</td>\n","      <td>601.666667</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>01.01.2019</td>\n","      <td>88001.0</td>\n","      <td>1213.0</td>\n","      <td>2019-01-01 04:49:00</td>\n","      <td>171.0</td>\n","      <td>Ebeersreye</td>\n","      <td>2.8</td>\n","      <td>20.1</td>\n","      <td>16.8</td>\n","      <td>15.5</td>\n","      <td>0</td>\n","      <td>14.6</td>\n","      <td>2019-01-01 04:51:00</td>\n","      <td>U Farmsen</td>\n","      <td>U S Barmbek</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>Ebeersreye|Rentenversicherung Nord</td>\n","      <td>01.01.2019</td>\n","      <td>2019-01-01 04:51:48</td>\n","      <td>2019-01-01 04:54:36</td>\n","      <td>168.0</td>\n","      <td>681.333333</td>\n","      <td>120.0</td>\n","      <td>670.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>01.01.2019</td>\n","      <td>88001.0</td>\n","      <td>1213.0</td>\n","      <td>2019-01-01 04:51:00</td>\n","      <td>171.0</td>\n","      <td>Rentenversicherung Nord</td>\n","      <td>3.6</td>\n","      <td>19.1</td>\n","      <td>45.9</td>\n","      <td>38.3</td>\n","      <td>0</td>\n","      <td>22.1</td>\n","      <td>2019-01-01 04:52:00</td>\n","      <td>U Farmsen</td>\n","      <td>U S Barmbek</td>\n","      <td>Sylter Weg</td>\n","      <td>Rentenversicherung Nord|Sylter Weg</td>\n","      <td>01.01.2019</td>\n","      <td>2019-01-01 04:54:36</td>\n","      <td>2019-01-01 04:55:24</td>\n","      <td>48.0</td>\n","      <td>294.666667</td>\n","      <td>60.0</td>\n","      <td>318.333333</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>983737</th>\n","      <td>26.01.2019</td>\n","      <td>88019.0</td>\n","      <td>1633.0</td>\n","      <td>2019-01-26 05:33:00</td>\n","      <td>11</td>\n","      <td>Schimmelmannstraße (Mitte)</td>\n","      <td>0.2</td>\n","      <td>14.3</td>\n","      <td>31.7</td>\n","      <td>28.5</td>\n","      <td>44</td>\n","      <td>26.3</td>\n","      <td>2019-01-26 05:35:00</td>\n","      <td>Am Hegen</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>Ziethenstraße</td>\n","      <td>Schimmelmannstraße (Mitte)|Ziethenstraße</td>\n","      <td>26.01.2019</td>\n","      <td>2019-01-26 05:33:12</td>\n","      <td>2019-01-26 05:34:24</td>\n","      <td>72.0</td>\n","      <td>526.000000</td>\n","      <td>120.0</td>\n","      <td>476.666667</td>\n","    </tr>\n","    <tr>\n","      <th>983738</th>\n","      <td>26.01.2019</td>\n","      <td>88019.0</td>\n","      <td>1633.0</td>\n","      <td>2019-01-26 05:35:00</td>\n","      <td>11</td>\n","      <td>Ziethenstraße</td>\n","      <td>-0.6</td>\n","      <td>42.2</td>\n","      <td>46.9</td>\n","      <td>42.7</td>\n","      <td>0</td>\n","      <td>34.7</td>\n","      <td>2019-01-26 05:36:00</td>\n","      <td>Am Hegen</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>Birtstraße</td>\n","      <td>Ziethenstraße|Birtstraße</td>\n","      <td>26.01.2019</td>\n","      <td>2019-01-26 05:34:24</td>\n","      <td>2019-01-26 05:35:24</td>\n","      <td>60.0</td>\n","      <td>578.333333</td>\n","      <td>60.0</td>\n","      <td>703.333333</td>\n","    </tr>\n","    <tr>\n","      <th>983739</th>\n","      <td>26.01.2019</td>\n","      <td>88019.0</td>\n","      <td>1633.0</td>\n","      <td>2019-01-26 05:36:00</td>\n","      <td>11</td>\n","      <td>Kedenburgstraße</td>\n","      <td>0.2</td>\n","      <td>17.3</td>\n","      <td>17.5</td>\n","      <td>15.6</td>\n","      <td>0</td>\n","      <td>15.3</td>\n","      <td>2019-01-26 05:38:00</td>\n","      <td>Am Hegen</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>Josephstraße</td>\n","      <td>Kedenburgstraße|Josephstraße</td>\n","      <td>26.01.2019</td>\n","      <td>2019-01-26 05:36:12</td>\n","      <td>2019-01-26 05:38:18</td>\n","      <td>126.0</td>\n","      <td>535.500000</td>\n","      <td>120.0</td>\n","      <td>576.666667</td>\n","    </tr>\n","    <tr>\n","      <th>983740</th>\n","      <td>26.01.2019</td>\n","      <td>88019.0</td>\n","      <td>1633.0</td>\n","      <td>2019-01-26 05:38:00</td>\n","      <td>11</td>\n","      <td>Josephstraße</td>\n","      <td>0.3</td>\n","      <td>16.0</td>\n","      <td>27.4</td>\n","      <td>24.3</td>\n","      <td>30</td>\n","      <td>24.2</td>\n","      <td>2019-01-26 05:41:00</td>\n","      <td>Am Hegen</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>Josephstraße|U Wandsbek Markt</td>\n","      <td>26.01.2019</td>\n","      <td>2019-01-26 05:38:18</td>\n","      <td>2019-01-26 05:40:06</td>\n","      <td>108.0</td>\n","      <td>726.000000</td>\n","      <td>180.0</td>\n","      <td>800.000000</td>\n","    </tr>\n","    <tr>\n","      <th>983741</th>\n","      <td>26.01.2019</td>\n","      <td>88019.0</td>\n","      <td>1633.0</td>\n","      <td>2019-01-26 05:42:00</td>\n","      <td>11</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>-1.3</td>\n","      <td>16.8</td>\n","      <td>-</td>\n","      <td>-</td>\n","      <td>19</td>\n","      <td>-</td>\n","      <td>2019-01-26 05:52:00</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>U Wandsbek Markt</td>\n","      <td>Source</td>\n","      <td>U Wandsbek Markt|Source</td>\n","      <td>26.01.2019</td>\n","      <td>2019-01-26 05:40:42</td>\n","      <td>2019-01-26 05:51:42</td>\n","      <td>660.0</td>\n","      <td>NaN</td>\n","      <td>600.0</td>\n","      <td>2800.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>983742 rows × 24 columns</p>\n","</div>"],"text/plain":["             Datum      UML   Wagen  ...  Distance_m Driving_time_s_p Distance_m_p\n","0       01.01.2019  88001.0  1213.0  ...  322.000000             60.0   316.666667\n","1       01.01.2019  88001.0  1213.0  ...  440.000000             60.0   421.666667\n","2       01.01.2019  88001.0  1213.0  ...  600.000000             60.0   601.666667\n","3       01.01.2019  88001.0  1213.0  ...  681.333333            120.0   670.000000\n","4       01.01.2019  88001.0  1213.0  ...  294.666667             60.0   318.333333\n","...            ...      ...     ...  ...         ...              ...          ...\n","983737  26.01.2019  88019.0  1633.0  ...  526.000000            120.0   476.666667\n","983738  26.01.2019  88019.0  1633.0  ...  578.333333             60.0   703.333333\n","983739  26.01.2019  88019.0  1633.0  ...  535.500000            120.0   576.666667\n","983740  26.01.2019  88019.0  1633.0  ...  726.000000            180.0   800.000000\n","983741  26.01.2019  88019.0  1633.0  ...         NaN            600.0  2800.000000\n","\n","[983742 rows x 24 columns]"]},"metadata":{"tags":[]},"execution_count":8}]},{"cell_type":"code","metadata":{"id":"yj9aNyAJZ9EB"},"source":["#data.to_csv('restructured_hochbahn.csv')\n","data_ist_fil.to_csv('IST_filter_01.csv')\n","!cp IST_filter_01.csv \"/content/drive/My Drive/Colab Notebooks/Thesis\""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"lG18vtIGd5NC"},"source":["!cp IST_filter_01.csv \"/content/drive/My Drive/Colab Notebooks/Thesis\""],"execution_count":null,"outputs":[]}]}